{"type":"doc","content":[{"type":"extension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"toc","parameters":{"macroParams":{"outline":{"value":"true"},"indent":{"value":"20px"},"style":{"value":"none"},"printable":{"value":"false"}},"macroMetadata":{"macroId":{"value":"cc26a45f-c755-451a-a559-e5db31c7c99a"},"schemaVersion":{"value":"1"},"title":"Table of Contents"}}}},{"type":"heading","attrs":{"level":1},"content":[{"text":"Overview","type":"text"}]},{"type":"paragraph","content":[{"text":"This module was created as a proof of concept (for embedding ","type":"text"},{"text":"Groovy","type":"text","marks":[{"type":"link","attrs":{"href":"http://groovy.codehaus.org/"}}]},{"text":" into OpenMRS) and to serve as a base module for other modules that want to use Groovy scripting as well.","type":"text"}]},{"type":"paragraph","content":[{"text":"For a quick overview of some of the cool groovy features, see this ","type":"text"},{"text":"spring source training video","type":"text","marks":[{"type":"link","attrs":{"href":"http://www.springsource.com/training/free-online-video-metaprogramming-groovy"}}]}]},{"type":"heading","attrs":{"level":1},"content":[{"text":"Setup","type":"text"}]},{"type":"paragraph","content":[{"text":"Download and install the Groovy module omod file from the ","type":"text"},{"text":"module repository","type":"text","marks":[{"type":"link","attrs":{"href":"https://addons.openmrs.org/#/show/org.openmrs.module.groovy"}}]},{"text":".","type":"text"},{"type":"hardBreak"},{"text":" (You can download the code from github: ","type":"text"},{"text":"https://github.com/openmrs/openmrs-module-groovy","type":"text","marks":[{"type":"link","attrs":{"href":"https://github.com/openmrs/openmrs-module-groovy"}}]},{"text":")","type":"text"}]},{"type":"heading","attrs":{"level":1},"content":[{"text":"Usage","type":"text"}]},{"type":"paragraph","content":[{"text":"Find and click on the ","type":"text"},{"text":"Groovy Scripting Form","type":"text","marks":[{"type":"em"}]},{"text":" link within the Groovy Module section of OpenMRS' administration page. You should be taken to a simple web form with a single textarea followed by a \"GO\" button. Type any valid Groovy script into the textarea and click the button to execute the script.","type":"text"}]},{"type":"paragraph","content":[{"text":"Some variables are automatically provided (most of these represent the API service):","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"admin","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"cohort","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"concept","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"encounter","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"form","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"locale","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"logic","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"obs","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"patient","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"person","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"user","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"fn (as of 2.2)","type":"text"}]}]}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Using fn","type":"text"}]},{"type":"paragraph","content":[{"text":"The special ","type":"text"},{"text":"fn","type":"text","marks":[{"type":"code"}]},{"text":" variable provides access to convenience functions:","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"fn.sql(\"select count(","type":"text","marks":[{"type":"code"}]},{"text":") from users\")","type":"text","marks":[{"type":"code"}]},{"type":"hardBreak"},{"text":" Runs the given SQL and returns the result set (only allows reading from database)","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"fn.sql(\"update users set name='Super-duper User' where user_id = 1\", false)","type":"text","marks":[{"type":"code"}]},{"type":"hardBreak"},{"text":" Runs SQL that can write to the database","type":"text"}]}]}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Scheduling Groovy Scripts","type":"text"}]},{"type":"paragraph","content":[{"text":"As of version 2.2, you can schedule Groovy scripts to run automatically using the scheduler.","type":"text"}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Create and save a groovy script","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Create a task (Scheduler within administration page) using the Schedulable Class: ","type":"text"},{"text":"org.openmrs.module.groovy.GroovyTask","type":"text","marks":[{"type":"code"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Add a property as follows:","type":"text"}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"name","type":"text","marks":[{"type":"strong"}]},{"text":": \"","type":"text"},{"text":"script name","type":"text","marks":[{"type":"strong"}]},{"text":"\" (the literal text, 'script name' without quotes... ","type":"text"},{"text":"not","type":"text","marks":[{"type":"em"}]},{"text":" the name of your script)","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"value","type":"text","marks":[{"type":"strong"}]},{"text":": ","type":"text"},{"text":"the name of your script","type":"text","marks":[{"type":"strong"}]}]}]}]}]}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Accessing Other Module Services","type":"text"}]},{"type":"paragraph","content":[{"text":"When trying to access the service of another module within a Groovy script, you might see a an error like:","type":"text"}]},{"type":"codeBlock","content":[{"text":"java.lang.NoClassDefFoundError: $Proxy109\n","type":"text"}]},{"type":"paragraph","content":[{"text":"If you do, try loading the service like this:","type":"text"}]},{"type":"codeBlock","attrs":{"language":"java"},"content":[{"text":"def mymodule = Context.getService(\n Context.loadClass(\n \"org.openmrs.module.mymoduleid.MyModuleService\"\n )\n);","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Reference: ","type":"text"},{"text":"developer mailing list discussion","type":"text","marks":[{"type":"link","attrs":{"href":"https://groups.google.com/a/openmrs.org/d/topic/dev/4l-y0Ytt4Oo/discussion"}}]}]}]}]},{"type":"heading","attrs":{"level":1},"content":[{"text":"Groovy script examples","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"List 100 concepts?","type":"text"}]},{"type":"codeBlock","content":[{"text":"import groovy.xml.MarkupBuilder\n\nwriter = new StringWriter()\nb = new MarkupBuilder(writer)\n\nb.table(border: 1) {\n 1.upto(100) {\n c = concept.getConcept(it)\n tr { td(c.name, style:\"font-weight:bold\"); td(c.name.description) }\n }\n}\nprintln writer\n","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Display some encounters?","type":"text"}]},{"type":"codeBlock","content":[{"text":"p = patient.getPatient(2)\nprintln \"

${p.givenName} ${p.familyName} Encounters

\"\nfor (e in encounter.getEncounters(p)) {\n println \"${String.format('%tF', e.encounterDatetime)} - ${e.creator}
\"\n println \"

${o.concept.name}

\"\n}\n","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Display some observations","type":"text"}]},{"type":"codeBlock","content":[{"text":"p = patient.getPatient(2)\nprintln \"

${p.givenName} ${p.familyName}

\"\nfor (o in obs.getObservations(p, false)) {\n println \"${o.concept.name} : ${o.getValueAsString(locale)}
\"\n}\n","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Search for patients by name","type":"text"}]},{"type":"codeBlock","content":[{"text":"s = \"nga\"\nfor (p in patient.getPatientsByName(s)) {\n n = \"${p.givenName} ${p.familyName}\".replaceAll(\"(?i)($s)\", \"\\$1\")\n println \"${n}
\"\n}\n","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Create providers for all users","type":"text"}]},{"type":"codeBlock","content":[{"text":"// provider service not yet provided by Groovy module (as of 2.2.1)\nprovider = org.openmrs.api.context.Context.getProviderService() \n\n// Get person IDs for all non-retired provider\nallProviderPersons = provider.allProviders\n .findAll{ !it.retired && it.person } // limit to non-retired w/ person\n .collect{ it.person.personId} // just grab person IDs\n\n// Get all non-retired users who aren't a provider\nusersWithoutProviders = user.allUsers\n .findAll{\n !it.retired // non-retired\n && it.username != 'daemon' // skip daemon user\n && !allProviderPersons.contains(it.person.personId) // skip if already a provider\n }\n\n// Create provider record for each user\nfor (u in usersWithoutProviders) {\n def p = new Provider()\n p.person = u.person\n person.save(p)\n}\n","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Create providers for users with specified roles","type":"text"}]},{"type":"codeBlock","content":[{"text":" import org.openmrs.Provider;\n\n targetRoles = [\"Provider\", \"Hospital Provider\", \"Health Agent\", \"ICS Provider\", \"Physical Therapist\", \"Surgeon\"]\n \n // provider service not yet provided by Groovy module (as of 2.2.1)\n provider = org.openmrs.api.context.Context.getProviderService() \n \n // Get person IDs for all non-retired provider\n allProviderPersons = provider.allProviders\n .findAll{ !it.retired && it.person } // limit to non-retired w/ person\n .collect{ it.person.personId} // just grab person IDs\n \n // Get all non-retired users who aren't a provider\n usersWithoutProviders = user.allUsers\n .findAll{\n !it.hasRole(\"System Developer\") && !it.retired && it.username != 'daemon' && it.username != 'ttest' &&!allProviderPersons.contains(it.person.personId) && it.roles.collect{it.name}.any{targetRoles.contains(it)}\n }\n \n // Create providers for users\n for (u in usersWithoutProviders) {\n def p = new Provider()\n p.person = u.person\n provider.saveProvider(p)\n }","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Execute SQL commands","type":"text"}]},{"type":"codeBlock","content":[{"text":"/*\n * Easy SQL example, displays number of users in database\n */\n\ndef sql(s) { admin.executeSQL(s,false) }\nrs = sql(\"select count(*) from users\")\nprintln \"Number of users ${rs}\"\n","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Manage modules","type":"text"}]},{"type":"codeBlock","content":[{"text":"import org.openmrs.module.ModuleFactory\n\n// Uncomment the next line to start the printing module\n// ModuleFactory.startModule(ModuleFactory.getModuleById(\"printing\"))\n\n// list out your running modules\nfor (m in ModuleFactory.startedModules) {\n println \"${m.name} : ${m.started}
\"\n // uncomment the next line to stop the printing module\n // if (m.name == \"Printing\") ModuleFactory.stopModule(m)\n}\n","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Delete program","type":"text"}]},{"type":"codeBlock","content":[{"text":"pid = 4\n\n// Get program\np = program.getProgram(pid)\nprintln \"

Program ${p.programId}: ${p.name} ${p.concept}
\"\n\nprogram.purgeProgram(p)\n","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Add Locations","type":"text"}]},{"type":"paragraph","content":[{"text":"Using groovy only:","type":"text"}]},{"type":"codeBlock","content":[{"text":"import org.openmrs.Location\n\nprintln \"\"\"\n

Adding locations:

\n\n \"\"\"\n\nlocationNames = [ \"Boucan Carre\", \"Belladeres\", \"Thomonde\", \"Lascahobas\", \"Cerca la Source\", \"Mirebalais\", \"St Marc SSPE\", \"POZ\", \"Petite Riviere\", \"Verrettes\", \"St Nicholas HSN\", \"Tilory\", \"Cerca Cavajal\", \"Thomassique\", \"Savanette\", \"Baptiste\", \"Maissade\", \"Dufailly\"]\n\ni = 0\nlocationNames.each() {\n def location = new Location()\n println \"\"\n location.setName(\"${it}\")\n location.setCountry(\"Haiti\")\n\nls = org.openmrs.api.context.Context.locationService\nls.saveLocation(location)\n}\n\nprintln \"

	Location name
${++i}	${it}

\"\n","type":"text"}]},{"type":"paragraph","content":[{"text":"Using mysql:","type":"text"}]},{"type":"codeBlock","content":[{"text":"println \"\"\"\n

Adding locations:

\n\n \"\"\"\n\nlocation = [ \"Boucan Carre\", \"Belladeres\", \"Thomonde\", \"Lascahobas\", \"Cerca la Source\", \"Mirebalais\", \"St Marc SSPE\", \"POZ\", \"Petite Riviere\", \"Verrettes\", \"St Nicholas HSN\", \"Tilory\", \"Cerca Cavajal\", \"Thomassique\", \"Savanette\", \"Baptiste\", \"Maissade\", \"Dufailly\"]\n\ni = 0\nlocation.each() {\n println \"\"\n admin.executeSQL(\"\"\"\n insert into location (name, country, creator, date_created, uuid)\n values(\"${it}\", 'Haiti', '1', now(), uuid() )\"\"\", false)\n}\n\nprintln \"

	Location name
${++i}	${it}

\"\n","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Print user and patients","type":"text"}]},{"type":"codeBlock","content":[{"text":"println \"\"\"\n

The following people are both patients and users in your system:

\n\n\"\"\"\n\ni = 0\nadmin.executeSQL(\"\"\"\nselect patient_id, identifier, system_id from patient_identifier, users\nwhere patient_id in (select user_id from users, patient where user_id = patient_id)\nand patient_id = user_id\nand not patient_identifier.voided\"\"\", false).each {\nprintln \"\"}\nprintln \"

	Internal ID	Patient	User
${++i}	\" + it.join(\"	\") + \"

\"\n","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Delete duplicate patients","type":"text"}]},{"type":"codeBlock","content":[{"text":"//List of userids with duplicate system_ids\nfor (uid in [20587, 22087, 18239, 18255, 18259, 18335, 18338, 18347,\n18352, 18356, 18377, 18387, 18389, 18393, 18401, 18407,\n18414, 18432, 18434, 18507, 17021 ] ) {\n\nu = user.getUser(uid)\nprintln \"

Original: ${u.systemId} ${u.userId} ${u.givenName} ${u.familyName}\"\n// Change and save system id for the first patient and print\nu.setSystemId(user.generateSystemId())\nuser.saveUser(u,null)\nprintln \"Replaced with: ${u.systemId} ${u.userId} ${u.givenName} ${u.familyName}

\"\n\n\n}\n","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Modify observation to use coded answer","type":"text"}]},{"type":"codeBlock","content":[{"text":"// This script will void non-coded diagnoses with 'HTA'\n// and create a new obs with a coded diagnosis for Hypertension\ndef reason = 'Migrate non-coded HTA to coded + '\n\n// Set the varibles\n// Non-coded concept diagnosis\ndef oldConceptId = 6543\n// Coded concept for diagnosis\ndef newConceptId = 6542\n// Coded answer for hypertension\ndef codedId = 903\n// Location is Lacolline only\ndef locationId = 7\n// Non-coded value_text\ndef diagnosis = \"HTA\"\n\nc = concept.getConcept(newConceptId)\nvc = concept.getConcept(codedId)\noc = concept.getConcept(oldConceptId)\nl = location.getLocation(locationId)\n\n// Loop thru all the obs where concept_id is for non-coded diagnosis, one location, and not voided\nfor (o in obs.getObservations(null,null,[oc],null,null,[l],null,null,null,null,null,false)) {\n\n // If the value_text is like the non-coded, print and change it\n if (o.valueText.toUpperCase() ==~ diagnosis ) {\n println \"${o.concept.name}: ${o.valueText}
\"\n\n // Void the non-coded obs; create coded concepts\n o.setConcept(c);\n o.setValueCoded(vc);\n o.setValueText(null);\n obs.saveObs(o,reason);\n }\n}\n","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Delete observations","type":"text"}]},{"type":"codeBlock","content":[{"text":"/ Delete observation\np = patient.getPatient(15919)\ne = encounter.getEncounter(39696)\n// Print name and location for patient\nprintln \"

${p.givenName} ${p.familyName} ${e.location}

\"\n\n// print information about the observations\nfor (o in obs.getObservations(p,false)) {\nif (o.location =\\~ 'Rwaza') {\nprintln \"${o.location} ${o.obsId} ${o.concept.name} : ${o.getValueAsString(locale)}
\"\n}\n}\n\n// obs_id for location 33 (Rwaza)\ndef numbers =\n\n// get observations and purge them\nfor (obsno in numbers) {\nthisObs = obs.getObs(obsno)\nprintln \"${thisObs.location} ${thisObs.obsId} ${thisObs.concept.name} ${thisObs.getValueAsString(locale)}
\"\nobs.purgeObs(thisObs)\n\n\n}\n","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Delete concept and concept answers","type":"text"}]},{"type":"codeBlock","content":[{"text":"conceptID = 3823\n\n\nc = concept.getConcept(conceptID);\nprintln \"

${c.conceptId} ${c.name}

\"\nfor (ca in c.getAnswers()) {\nprintln \"

${ca.concept.conceptId} ${ca.conceptAnswerId} ${ca.answerConcept}

\"\n\n// This works, but isn't saved\nc.removeAnswer(ca)\n}\n\n//This doesn't save the removed answers\nconcept.saveConcept(c)\n\n// This proves that it is removed\nprintln \"Second pass\\n\"\nfor (ca2 in c.getAnswers()) {\nprintln \"

${ca2.concept.conceptId} ${ca2.conceptAnswerId} ${ca2.answerConcept}

\"\n}\n\n// This won't work until the answers are deleted\n//concept.deleteConcept(concept.getConcept(conceptID))\n","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Change program and workflow","type":"text"}]},{"type":"codeBlock","content":[{"text":"// What are the program_id and workflow_id?\n// Get these from the GUI\n// IMPORTANT: These variables are real for Rwanda and HEART FAILURE PROGRAM and DIAGNOSIS WORKFLOW\n// Otherwise...replace with the real numbers\npid = 11\nwid = 21\n// Get program\np = program.getProgram(pid)\nprintln \"

Program ${p.programId}: ${p.name} ${p.concept}
\"\n\n// Get program workflow\npw = program.getWorkflow(wid)\nprintln \"

Workflow ${pw.programWorkflowId}: ${pw.concept} ${pw.concept.name} ${pw.program.programId}
${pw.program}

\"\n\n// Get all states and delete the states for the appropriate workflows\nfor (s in program.getStates()) {\nprintln \"

States ${s.programWorkflowStateId}: ${s.concept} ${s.concept.name}
${s.programWorkflow}

\"\npw.removeState(s)\n}\n\n// Save the removed workflow and save the program\n// NOTE: Uncomment the next 2 lines after testing\n//p.removeWorkflow(pw)\n//program.saveProgram(p)\n","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Change person","type":"text"}]},{"type":"codeBlock","content":[{"text":"// Change the Given name for a Person\n\n// Variables\nperson_id = 20754\nnew_given_name = \"MBASABYAMAHORO\"\nnew_birthdate = \"1980-01-01 00:00:00.0\"\n\n// Second patient\n//person_id = 1588\n//new_given_name = \"Claudine\"\n//new_family_name = \"MUKARURANGA\"\n\n// Get person\np = person.getPerson(person_id)\nname = p.getNames()\nbd = p.getBirthdate()\n\n// Print out current values\ngiven_name = p.getGivenName()\nfamily_name = p.getFamilyName()\nprintln \"

Original given name: ${given_name}
\"\nprintln \"

Original family name: ${family_name}
\"\nprintln \"

Birthdate: ${bd}
\"\n\n// Get person name\npn = p.getPersonName()\nprintln \"

Person name: ${pn}
\"\npn.setGivenName(new_given_name)\n//pn.setFamilyName(new_family_name)\n\n// Add and save the corrected name\np.addName()\nperson.savePerson(p)\n\n// Print the corrected values\ncname = p.getNames()\nprintln \"

Corrected name: ${cname}

\"\n\n","type":"text"}]},{"type":"paragraph","content":[{"text":"Or this simple script","type":"text"}]},{"type":"codeBlock","content":[{"text":"import org.openmrs.PersonName\np = person.getPerson(1);\np.addName(new PersonName(\"Given\", \"middle name\", \"Family\"));\nperson.savePerson(p);\n","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Change form id","type":"text"}]},{"type":"paragraph","content":[{"text":"This used when we duplicate an InfoPath form into htmlform, and want to change all the infopath forms to use htmlform view/edit capabilities.","type":"text"}]},{"type":"codeBlock","content":[{"text":"// Original formId of Infopath form\ninfopathFormId = 82\n\n// formId of htmlform form\nhtmlformId = 188\n\nf = form.getForm(infopathFormId)\nhtmlform = form.getForm(htmlformId)\n\nfor (e in encounter.getEncounters(null,null,null,null,[f],null,null,true)) {\n if (e.getForm().getFormId() == infopathFormId) {\n e.setForm(htmlform)\n }\n encounter.saveEncounter(e)\n}\n","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Retire form","type":"text"}]},{"type":"codeBlock","content":[{"text":"// Set variables\nform_id = 99\nuser_id = 7\nreason = 'Form no longer needed'\ndef today= new Date()\n\nu = user.getUser(user_id)\n\nf = form.getForm(form_id)\n\n// Print form information\nprintln \"

Old Form: ${f} ${f.name}\"\nprintln \" ${f.retired} ${f.retiredBy} ${f.retiredReason} ${f.dateRetired} \"\n\n// Set form to retired\nf.setRetired(true)\nf.setRetiredBy(u)\nf.setRetiredReason(reason)\nf.setDateRetired(today)\n\nform.saveForm(f)\n\n// Print form information\nprintln \"Saved Form: ${f} ${f.name}\"\nprintln \" ${f.retired} ${f.retiredBy} ${f.retiredReason} ${f.dateRetired}

\"\n","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Delete forms (with no encounters)","type":"text"}]},{"type":"codeBlock","content":[{"text":"import org.openmrs.FormField\n\n// delete all formfield rows, but need to null the parent first\nfor (ff in form.getAllFormFields() ) {\n // set parent_form_field to NULL\n ff.setParent(null)\n form.saveFormField(ff) }\n\nfor (ff2 in form.getAllFormFields() ) {\n form.deleteFormField(ff2) }\n\nfor ( form_id in [9,10,11,12] ) {\n // get form_id\n f = form.getForm(form_id)\n\n // delete the formentry_xsn rows // This next line requires a change to the groovy module (see GRV-18)\n formEntry.deleteFormEntryXsn(f)\n\n // Print form information\n println \"

deleting form: ${f} ${f.name}\"\n\n // delete each form\n form.deleteForm(f)\n}\n","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Retire drug","type":"text"}]},{"type":"codeBlock","content":[{"text":"// Set variables\ndrug_id = 11\nuser_id = 7\nreason = 'test retire'\ndef today= new Date()\n\nu = user.getUser(user_id)\nd = concept.getDrug(drug_id)\n\n// Print drug information\nprintln \"

Old drug: ${d} ${d.name}\"\nprintln \" ${d.retired} ${d.retiredBy} ${d.retireReason} ${d.dateRetired}

\"\n\n// Set form to retired\nd.setRetired(true)\nd.setRetiredBy(u)\nd.setRetireReason(reason)\nd.setDateRetired(today)\nconcept.saveDrug(d)\n","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Remove birthdates","type":"text"}]},{"type":"paragraph","content":[{"text":"This is useful when no birthdate is known and bogus ages are selected (ie. 106 years old)","type":"text"}]},{"type":"codeBlock","content":[{"text":"// remove bogus birthdates\n\nfor (person_id in [4,5] ) {\n\n // Get person\n p = person.getPerson(person_id)\n\n // Print out current values\n bd = p.getBirthdate()\n pn = p.getPersonName()\n println \"

Person name: ${pn} Birthdate: ${bd}
\"\n\n // Remove birthdate\n p.setBirthdate(null)\n p.setBirthdateEstimated(false)\n person.savePerson(p)\n}\n","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Print concept sets and names ","type":"text"}]},{"type":"codeBlock","content":[{"text":"set = concept.getConcept(3642);\nfor (sm in set.conceptSets) {\n println(sm.conceptSetId + \" , \" + sm.concept.conceptId + \" , \" \n + sm.conceptSet.conceptId + \" , \" + sm.sortWeight + \" , \"\n + sm.dateCreated + \" , \" + sm.uuid);\n println(\" = \");\n println(sm.concept.names);\n println(\" \"); \n}\n","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Void concept names","type":"text"}]},{"type":"codeBlock","content":[{"text":"// Void these concept_names\ndef conceptNameIds = [13932, 13662, 13778,13670,7105,11259,13310, 13935, 13731, 13460,13284,10000,9860];\n\ndef reason = 'Duplicate name removed for OpenMRS 1.9'\ndef today= new Date()\ndef user_id = 1010\n\nu = user.getUser(user_id)\n\nfor (conceptNameId in conceptNameIds) {\n\n org.openmrs.ConceptName name = concept.getConceptName(conceptNameId);\n org.openmrs.Concept c = name.getConcept()\n\n name.setVoided(true);\n name.setVoidedBy(u);\n name.setDateVoided(today);\n name.setVoidReason(reason);\n\n println \"

${name.name}

\"\n\n concept.saveConcept(c);\n}\n","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Change ConceptSource","type":"text"}]},{"type":"paragraph","content":[{"text":" ","type":"text"}]},{"type":"codeBlock","content":[{"text":"def sourceName = 'IMB Rwanda' \ndef newName = 'Rwanda' \ndef newCode = '' \ndef newDesc = 'Rwanda harmonized concepts for MoH and IMB'\n\nsource = org.openmrs.api.context.Context.getConceptService().getConceptSourceByName(sourceName); \nprintln \"

Name: ${source.getConceptSourceId()} ${source.getName()}
\" \n\nsource.setName(newName) \nsource.setHl7Code(newCode) \nsource.setDescription(newDesc)\n","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Change concept_map comment (for OpenMRS 1.9 upgrade)","type":"text"}]},{"type":"codeBlock","content":[{"text":"def oldTypeName = \"Map Type: 3\";\ndef typeName = \"Map Type: BROADER-THAN\";\ndef sourceNames = [\"ICD-10\",\"SNOMED NP\",\"ICD-10-WHO NP\", \"ICD-10-WHO 2nd\"];\nfor (sourceName in sourceNames) {\n org.openmrs.ConceptSource source = concept.getConceptSourceByName(sourceName);\n List conceptMaps = concept.getConceptsByConceptSource(source);\n for (conceptMap in conceptMaps) {\n if (oldTypeName.equals(conceptMap.getComment())) {\n println \"

Map: ${conceptMap.concept}: ${conceptMap.comment}
\"\n conceptMap.setComment(typeName);\n concept.saveConcept(conceptMap.getConcept());\n }\n }\n}\n","type":"text"}]},{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"codeBlock","content":[{"text":"def typeName = \"Map Type: SAME-AS\";\ndef sourceNames = [\"PIH\",\"org.openmrs.module.mdrtb\",\n \"local\",\"AMPATH\",\"ZL/PIH installation in Haiti\",\n \"ZL/PIH installation in Haiti - Boston server\",\n \"MVP/CIEL at PIH\"];\nfor (sourceName in sourceNames) {\n org.openmrs.ConceptSource source = concept.getConceptSourceByName(sourceName);\n List conceptMaps = concept.getConceptsByConceptSource(source);\n for (conceptMap in conceptMaps) {\n if (!typeName.equals(conceptMap.getComment())) {\n println \"

Map: ${conceptMap.concept}: ${conceptMap.comment}
\"\n conceptMap.setComment(typeName);\n concept.saveConcept(conceptMap.getConcept());\n }\n }\n}\n","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Remove role","type":"text"}]},{"type":"codeBlock","content":[{"text":"roleName = \"Patient Registration\"\nus = org.openmrs.api.context.Context.userService\nr = us.getRole(roleName)\nprintln \"

Role: ${r.role}
description: ${r.description}
uuid: ${r.uuid}
\"\nus.purgeRole(r)\n","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"A more complex example","type":"text"}]},{"type":"codeBlock","content":[{"text":"/\\*\n* For adult return visits within two clinic modules during November 2008, examine the CD4 counts\n* available to the clinician at the time of the encounter, calculate several decision support reminder\n* triggers, and then output -- as comma-separated values -- each visit along with whether or not each\n* reminder would have been triggered, whether the clinician ordered a CD4 count at the visit, and whether\n* or not a CD4 was obtained during the visit (or within the following week). Include all known CD4 counts\n* the the patient at the end of each line for quick validation.\n\\*/\nimport org.openmrs.Obs\nimport org.openmrs.Person\nimport org.openmrs.Encounter\n\n// Easy SQL calls\ndef sql(s) { admin.executeSQL(s,false) }\n\n// Desired date format\ndef df = new java.text.SimpleDateFormat('MM/dd/yyyy')\n\n// Used to compare observations -- e.g., to find max/min\ndef byValue = \\[compare:{ a, b -> a.valueNumeric <=> b.valueNumeric }\\] as Comparator\ndef byDate = \\[compare:{ a, b -> a.obsDatetime <=> b.obsDatetime }\\] as Comparator\n\n// Some magic Groovy Obs methods\nObs.metaClass.'asOf' = { Date d -> delegate.obsDatetime < d }\nObs.metaClass.'above' = { value -> delegate.valueNumeric > value }\nObs.metaClass.'below' = { value -> delegate.valueNumeric < value }\nObs.metaClass.'text' = { \"${delegate.valueNumeric} on ${df.format(delegate.obsDatetime)}\" }\n\n// Add some magic to lists (ArrayList is Groovy's default for lists) for convenience\nArrayList.metaClass.'asOf' = { Date d \\-> delegate.findAll{ it.asOf(d) }}\nArrayList.metaClass.'text' = { delegate.collect{it.text()} }\n\n// More Groovy fun: checking list sizes in a way a doctor might understand -- e.g., 2.of(this) && 3.orMore(that)\nInteger.metaClass.'of' = { list -> list != null && list.size() == delegate }\nInteger.metaClass.'orMore' = { list -> list != null && list.size() >= delegate }\n\n// And why not make it easy to lookup CD4s or identifiers using internal IDs while we're enjoying Groovy magic\ndef CD4_CONCEPT = concept.getConcept(5497) // Our CD4 concept\nInteger.metaClass.'cd4s' = { obs.getObservationsByPersonAndConcept(new Person(delegate),CD4_CONCEPT) }\nInteger.metaClass.'identifiers' = { patient.getPatient(delegate).identifiers.collect{ it.identifier } }\n\n// Fetch names of target locations\ntargetLocations = [13, 14] // 13 = Module 2, 14 = Module 3\nlocation = org.openmrs.api.context.Context.locationService\nlocationName = []; targetLocations.each { locationName[it] = location.getLocation(it).name }\n\n// Methods to check for orders or results reported within an encounter\ndef TESTS_ORDERED = concept.getConcept(1271) // Our TEST ORDERED concept\ndef CD4_PANEL = concept.getConcept(657) // Our CD4 PANEL concept (answer to TESTS ORDERED if doctor ordered a CD4)\n// Return true if CD4 ordered within encounter for patient\ndef cd4Ordered = { pid, encId \\->\n1.orMore(obs.getObservations([new Person(pid)|new Person(pid)],[new Encounter(encId)|new Encounter(encId)],[TESTS_ORDERED|TESTS_ORDERED],\n[CD4_PANEL|CD4_PANEL],null,null,null,null,null,null,null,false))\n}\n// Return true if CD4 result within one week of encounter date\ndef cd4Obtained = { pid, encDate \\->\n1.orMore(obs.getObservations([new Person(pid)|new Person(pid)],null,[CD4_CONCEPT|CD4_CONCEPT],\nnull,null,null,null,null,null,encDate-1,encDate+7,false))\n}\n\n// Our reminders\ndef reminders = \\[\n// No prior CD4\n1 : { encDate, cd4s -> cd4s == null || 0.of(cd4s) },\n\n// Only one CD4 over 6 months ago\n// TODO: need to match Brian's logic for what \"6 months\" means\n2 : { encDate, cd4s -> 1.of(cd4s) && cd4s[0].asOf(encDate-180) },\n\n// Only two prior CD4s, at least one < 400, both over 6 months ago\n3 : { encDate, cd4s -> 2.of(cd4s) && cd4s.min(byValue).below(400) && cd4s.max(byDate).asOf(encDate-180) },\n\n// More than two prior CD4s, latest < 400 and over 6 months ago\n4 : { encDate, cd4s -> 3.orMore(cd4s) && cd4s.max(byDate).below(400) && cd4s.max(byDate).asOf(encDate-180) },\n\n// More than two prior CD4s (or only two if both >400) with most recent over 12 months ago and >400\n5 : { encDate, cd4s -> (3.orMore(cd4s) || (2.of(cd4s) && cd4s.min(byValue).above(400)))\n && cd4s.max(byDate).asOf(encDate - 365) }\n\n\\] // end of reminders\n\n// Select adult return visit encounters at our target locations between 3-Nov-2008 and 28-Nov-2008\nrs = sql(\"\"\"\nselect patient_id, encounter_id, encounter_datetime, location_id\nfrom encounter\nwhere encounter_datetime >= '2008-11-03' and encounter_datetime < '2008-11-29'\nand encounter_type = 2 /\\* ADULTRETURN encounter type \\*/\nand location_id in (${targetLocations.join(',')})\n\"\"\")\n\n// Loop through the encounters, creating a CSV output\nprintln \"Date,Patient,pid,Encounter,Module,${reminders.keySet().join(',')},Any,Ordered,Obtained,CD4s\"\nrs.each { row \\->\n(pid, encId, encDate, locationId) = row\nidentifier = pid.identifiers()[0] // first patient identifier is preferred\nmodule = locationName[locationId] // the clinic module\nallCd4s = pid.cd4s() // all known CD4 counts for the patient\ncd4s = allCd4s.asOf(encDate) // only CD4s prior to the current encounter\nordered = cd4Ordered(pid, encId) ? 'Y' : 'N'\nobtained = cd4Obtained(pid, encDate) ? 'Y' : 'N'\nreminderResults = reminders.collect { n, fn -> fn(encDate,cd4s) ? 1 : 0 } // one line runs our reminders\nanyReminder = reminderResults.sum() > 0 ? 1 : 0\n\n// output in CSV format\nprint \"${df.format(encDate)},$identifier,$pid,$encId,$module,${reminderResults.join(',')},$anyReminder,\"\nprint \"\"\"$ordered,$obtained,\"${allCd4s.sort(byDate).reverse().text().join(',')}\"\\n\"\"\"\n}\n","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Trigger Sync for a Patient (may not be complete)","type":"text"}]},{"type":"codeBlock","content":[{"text":"import java.util.*;\nimport org.openmrs.*;\nimport org.openmrs.api.*;\nimport org.openmrs.api.context.Context;\n\nString patientUuid = null;\n\nDate now = new Date();\n\nif (patientUuid != null) {\n p = patient.getPatientByUuid(patientUuid);\n p.setDateChanged(now);\n\n for (pn in p.names) {\n pn.setDateChanged(now);\n }\n\n for (pa in p.addresses) {\n pa.setDateChanged(now);\n }\n\n for (pa in p.attributes) {\n pa.setDateChanged(now);\n }\n\n for (pi in p.identifiers) {\n pi.setDateChanged(now);\n }\n\n patient.savePatient(p);\n println \"Saved Patient \" + p;\n\n for (r in person.getRelationshipsByPerson(p)) {\n r.setDateChanged(now);\n person.saveRelationship(r);\n println \"Saved relationship \" + r;\n }\n\n for (e in encounter.getEncountersByPatient(p)) {\n e.setDateChanged(now);\n if (e.visit != null) {\n e.visit.setDateChanged(now);\n }\n for (o in e.orders) {\n o.setDateChanged(now);\n }\n for (o in e.obs) {\n o.setDateChanged(now);\n }\n\n for (ep in e.encounterProviders) {\n ep.setDateChanged(now);\n if (ep.encounterRole != null) {\n ep.encounterRole.setDateChanged(now);\n }\n }\n encounter.saveEncounter(e);\n println \"Saved encounter \" + e;\n }\n\n visitService = Context.getService(VisitService.class);\n for (v in visitService.getVisitsByPatient(p)) {\n v.setDateChanged(now);\n visitService.saveVisit(v);\n println \"Saved visit \" + v;\n }\n\n for (o in order.getDrugOrdersByPatient(p, OrderService.ORDER_STATUS.ANY, true)) {\n Date dateCreated = o.getDateCreated();\n Calendar cal = Calendar.getInstance();\n cal.setTime(dateCreated);\n cal.add(Calendar.SECOND, 1);\n o.setDateCreated(cal.getTime());\n order.saveOrder(o);\n println \"Saved drug order \" + o;\n }\n\n for (o in obs.getObservationsByPerson(p)) {\n if (o.encounter == null) {\n Date dateCreated = o.getDateCreated();\n Calendar cal = Calendar.getInstance();\n cal.setTime(dateCreated);\n cal.add(Calendar.SECOND, 1);\n o.setDateCreated(cal.getTime());\n obs.saveObs(o, 'Resaving patient and all data for sync');\n println \"Saved obs \" + o;\n }\n }\n\n for (pp in program.getPatientPrograms(p, null, null, null, null, null, true)) {\n pp.setDateChanged(now);\n for (ps in pp.states) {\n ps.setDateChanged(now);\n }\n program.savePatientProgram(pp);\n println \"Saved patient program \" + pp.id;\n }\n}\nelse {\n println \"You need to enter a patientUuid at the top of the script to use it\"\n}\n","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Make REST web service calls","type":"text"}]},{"type":"panel","attrs":{"panelType":"error"},"content":[{"type":"paragraph","content":[{"text":"Make sure you don't save your password in a script! You can enter your password into this script and run it, but make sure to remove your password before saving the script!","type":"text"}]}]},{"type":"paragraph","content":[{"text":"The following script sets up basic authentication, makes a call to the ","type":"text"},{"text":"REST Web Services","type":"text","marks":[{"type":"link","attrs":{"href":"https://openmrs.atlassian.net/wiki/spaces/docs/pages/25469830"}}]},{"text":" module, and then displays the result.","type":"text"}]},{"type":"panel","attrs":{"panelType":"success"},"content":[{"type":"paragraph","content":[{"text":"Copy the JSON-formatted result into an editor like ","type":"text"},{"text":"Sublime Text 2","type":"text","marks":[{"type":"link","attrs":{"href":"http://www.sublimetext.com/2"}}]},{"text":" with a JSON formatter (in Sublime Text 2, Tools > Command Palette > Package Control : Install Package > Pretty JSON) to quickly format the JSON into a more legible form.","type":"text"}]}]},{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"codeBlock","attrs":{"language":"groovy"},"content":[{"text":"username = \"admin\"\npassword = \"test\"\nAuthenticator.setDefault (new Authenticator() {\n protected PasswordAuthentication getPasswordAuthentication() {\n return new PasswordAuthentication (username, password.toCharArray());\n }\n});\nnew URL(\"http://localhost:8081/openmrs-standalone/ws/rest/v1/person?q=darius\")\n .text.replaceAll(\",\",\",\\n\")","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Look for HTML Forms that have the same concept repeated, without extra contextual information","type":"text"}]},{"type":"codeBlock","attrs":{"language":"groovy"},"content":[{"text":"import org.openmrs.api.context.Context\n\n// 6042 is free-text diagnosis\ndef ignoreWarningsFor = [ \"6042\" ]\n\ndef loadInstance = { className ->\n return Context.loadClass(className).newInstance()\n}\n\ndef HtmlFormEntryUtil = loadInstance(\"org.openmrs.module.htmlformentry.HtmlFormEntryUtil\")\ndef FormEntryContext = loadInstance(\"org.openmrs.module.htmlformentry.FormEntryContext\")\n\ndef FormEntrySessionClass = Context.loadClass(\"org.openmrs.module.htmlformentry.FormEntrySession\")\ndef HtmlFormClass = Context.loadClass(\"org.openmrs.module.htmlformentry.HtmlForm\")\n\ndef service = Context.getService(Context.loadClass(\"org.openmrs.module.htmlformentry.HtmlFormEntryService\"))\n\ndef getSchema = { hf ->\n def constructor = FormEntrySessionClass.constructors.find {\n def helper = it.parameterTypes.collect { it.name }.join(\",\")\n return helper == \"org.openmrs.Patient,org.openmrs.module.htmlformentry.HtmlForm,javax.servlet.http.HttpSession\"\n }\n def fes = constructor.newInstance(HtmlFormEntryUtil.getFakePerson(), hf, null);\n return fes.getContext().getSchema();\n}\n\ndef obsFieldSignature = { obsField ->\n def temp = \"${ obsField.question.id }\"\n if (obsField.answers) {\n temp += \"(\" + obsField.answers.collect { it.concept.id } .join(\", \") + \")\"\n }\n return temp;\n}\n\ndef checkForUnsafeObsFields = { prefix, fields ->\n println(\"(debug) looking at ${ prefix }\")\n def questionsUsed = new TreeSet();\n fields.each {\n if (it.class.simpleName == \"ObsField\") {\n def obsFieldSig = obsFieldSignature(it)\n if (questionsUsed.contains(obsFieldSig) && !ignoreWarningsFor.contains(obsFieldSig)) {\n println(\"${ prefix } -> Warning about ${ obsFieldSig }\")\n }\n questionsUsed.add(obsFieldSig)\n }\n }\n}\n\ndef checkField\ncheckField = { prefix, field ->\n def test = field.class.simpleName\n if (\"HtmlFormSection\" == test) {\n def name = \"${prefix} -> (Section) ${field.name} \"\n checkForUnsafeObsFields(name, field.fields)\n field.fields.each {\n checkField(name, it)\n }\n } else if (\"ObsGroup\" == test) {\n def name = \"${prefix} -> (ObsGroup) ${field.concept.name.name} \"\n checkForUnsafeObsFields(name, field.children)\n field.children.each {\n checkField(name, it)\n }\n }\n}\n\ndef checkFields = { prefix, fields ->\n fields.each {\n checkField(prefix, it)\n }\n}\n\nservice.allHtmlForms.each { hf ->\n println(\"=== ${ hf.name } ===\")\n def schema = getSchema(hf)\n println(\"Schema has ${ schema.allFields.size() } fields\")\n checkFields(\" \", schema.allFields)\n}\n\n\"Done.\"\n","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Update a Person Attribute and insert an Obs given a value from another Obs","type":"text"}]},{"type":"paragraph","content":[{"text":" ","type":"text"}]},{"type":"codeBlock","content":[{"text":"/**********\nIf concepts\n celular del paciente que dio el paciente o celular modificado are \nlater than latest changed by date for cel attribute\n* place them in the celular history and then in the patient attribute\n********/\n\n import org.openmrs.api.context.Context\n import org.openmrs.api.EncounterService;\n import org.openmrs.module.groovy.GroovyUtil\n import org.openmrs.Encounter;\n import java.lang.Integer;\n import org.openmrs.EncounterType;\n import org.openmrs.Person;\n import org.openmrs.Patient;\n import org.openmrs.Obs;\n import org.openmrs.PersonAttribute;\n import org.openmrs.Concept;\n import org.hibernate.SessionFactory;\n import org.openmrs.api.FormService;\n import org.openmrs.api.ObsService;\n import org.openmrs.api.ConceptService;\n import org.openmrs.api.PersonService;\n import org.openmrs.Location;\n \n sf = Context.serviceContext.applicationContext.getBean(SessionFactory.class)\n ObsService os = Context.getObsService()\n ConceptService cs = Context.getConceptService();\n PersonService ps = Context.getPersonService();\n \ndef sql(s) { admin.executeSQL(s,false) }\n\nrs = sql(\"\"\"\nselect p.patient_id as pid,REPLACE(FORMAT(o.value_numeric, 0), ',', '') as celular from patient p, obs o, person_attribute pa where p.patient_id = o.person_id and p.patient_id = pa.person_id and pa.person_attribute_type_id = 8 and o.concept_id in (331,138) and o.voided=0 and p.voided=0 and pa.voided=0 and IF(pa.date_changed is not null, pa.date_changed, pa.date_created) < o.obs_datetime and pa.value != o.value_numeric;\n\"\"\")\n\nrs.each { row ->\n (pid,celular) = row\n Obs o = new Obs();\nprint celular\n o.setConcept(cs.getConcept(260));\n o.setDateCreated(new Date());\n o.setCreator(Context.getAuthenticatedUser());\n o.setLocation(new Location(1));\n o.setObsDatetime(new Date());\n o.setPerson(new Person(pid));\n o.setValueText(celular.toString());\n os.saveObs(o,\"inserted by groovy script\");\n \n PersonAttribute pa = new PersonAttribute();\n def t = ps.getPersonAttributeType(new Integer(8));\n pa.setAttributeType(t);\n\n def p = ps.getPerson(new Patient(pid));\n pa.setPerson(new Person(pid));\n pa.setValue(celular.toString());\n pa.setDateChanged(new Date());\n p.addAttribute(pa);\n ps.savePerson(p);\n\n //print e\n}","type":"text"}]},{"type":"paragraph","content":[{"text":"A slightly groovier way","type":"text"}]},{"type":"codeBlock","content":[{"text":"/**********\nIf concepts\n celular del paciente que dio el paciente o celular modificado are \nlater than latest changed by date for cel attribute\n* place them in the celular history and then in the patient attribute\n********/\n\n import org.openmrs.api.context.Context\n import org.openmrs.api.EncounterService;\n import org.openmrs.module.groovy.GroovyUtil\n import org.openmrs.Encounter;\n import java.lang.Integer;\n import org.openmrs.EncounterType;\n import org.openmrs.Person;\n import org.openmrs.Patient;\n import org.openmrs.Obs;\n import org.openmrs.PersonAttribute;\n import org.openmrs.Concept;\n import org.hibernate.SessionFactory;\n import org.openmrs.api.FormService;\n import org.openmrs.api.ObsService;\n import org.openmrs.api.ConceptService;\n import org.openmrs.api.PersonService;\n import org.openmrs.Location;\n \n sf = Context.serviceContext.applicationContext.getBean(SessionFactory.class)\n ObsService os = Context.getObsService()\n ConceptService cs = Context.getConceptService();\n PersonService ps = Context.getPersonService();\n \ndef sql(s) { admin.executeSQL(s,false) }\n\nrs = sql(\"\"\"\nselect p.patient_id as pid,REPLACE(FORMAT(o.value_numeric, 0), ',', '') as celular from patient p, obs o, person_attribute pa where p.patient_id = o.person_id and p.patient_id = pa.person_id and pa.person_attribute_type_id = 8 and o.concept_id in (331,138) and o.voided=0 and p.voided=0 and pa.voided=0 and IF(pa.date_changed is not null, pa.date_changed, pa.date_created) < o.obs_datetime and pa.value != o.value_numeric;\n\"\"\")\n\nrs.each { row ->\n (pid,celular) = row\n\n def o = new Obs()\n def pa = new PersonAttribute()\n o.concept = concept.getConcept(260)\n o.dataCreated = new Date()\n o.creator = Context.authenticatedUser\n o.location = new Location(1)\n o.obsDatetime = new Date()\n o.person = new Patient(pid)\n o.encounter = new Encounter(enc_id)\n o.valueText = celular\n obs.saveObs(o,\"inserted by groovy script\")\n \n pa.person = new Patient(pid)\n pa.attributeType = person.getPersonAttributeType(8)\n pa.value = celular\n pa.dateChanged = new Date()\n}","type":"text"}]},{"type":"heading","attrs":{"level":1},"content":[{"text":"Troubleshooting","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"java.lang.ClassFormatError: Invalid method Code length 82342 in class file Script1","type":"text"}]},{"type":"paragraph","content":[{"text":"Solution: Java only allows methods that are 64K long. Reduce the size of your groovy script.","type":"text"}]}],"version":1}

Browser not supported