Hi Ketta,
If you're interested in an immediate work-around you could write some custom SQL and put it into a BIRT report. The following SQL might get you close to where you're wanting to go... SELECT (SELECT name FROM form WHERE form.form_id=encounter.form_id) as 'Form Name', count( form_id ) as 'Number Completed' FROM `encounter` WHERE voided =0 AND encounter_datetime > DATE_SUB(NOW(),INTERVAL 1 YEAR) AND patient_id=YOUR_PATIENT_ID GROUP BY form_id It yields something like this... Form Name <http://intranet.hashaiti.org:81/phpMyAdmin/sql.php?db=openmrs&table=encounter&sql_query=SELECT+%28SELECT+name+FROM+form+WHERE+form.form_id%3Dencounter.form_id%29+as+%27Form+Name%27%2C+count%28+form_id+%29+as+%27Number+Completed%27%0AFROM+%60encounter%60%0AWHERE+voided+%3D0+%0AAND+encounter_datetime+%3E+DATE_SUB%28NOW%28%29%2CINTERVAL+1+YEAR%29%0AAND+patient_id%3D602158%0AGROUP+BY+form_id+ORDER+BY+%60Form+Name%60+ASC&token=1777702b58b0350bc8cd5005e2f7254c> Number Completed <http://intranet.hashaiti.org:81/phpMyAdmin/sql.php?db=openmrs&table=encounter&sql_query=SELECT+%28SELECT+name+FROM+form+WHERE+form.form_id%3Dencounter.form_id%29+as+%27Form+Name%27%2C+count%28+form_id+%29+as+%27Number+Completed%27%0AFROM+%60encounter%60%0AWHERE+voided+%3D0+%0AAND+encounter_datetime+%3E+DATE_SUB%28NOW%28%29%2CINTERVAL+1+YEAR%29%0AAND+patient_id%3D602158%0AGROUP+BY+form_id+ORDER+BY+%60Number+Completed%60+ASC&token=1777702b58b0350bc8cd5005e2f7254c> Vizit nan Pòs Swen Sante 5 Notifikasyon Malnitrisyon 25 You could either use YOUR_PATIENT_ID as a variable that you enter when the report is run (if doing so, you should probably do a lookup of using the identifier), or use the Reports tab on the patient dashboard and have it run for that patient. You can find more information on the BIRT Module on the wiki at... https://wiki.openmrs.org/display/docs/BIRT+Report+Module Thanks, James From: [email protected] [mailto:[email protected]] On Behalf Of Ketta Levi Martin Sent: Friday, February 24, 2012 4:59 AM To: [email protected] Subject: [OPENMRS-IMPLEMENTERS] Having a Count of Entry Records Using OpenMRS Hi, I would like to know if there is a possibility of having a count of entries/forms for a patient in a given period(e.g. One Year). Could there be a module to do that within the Cohort Analysis tab? -- Martin Levi Ketta P.O. Box 1292 Masaka - Uganda Mob: +256 752808383 ________________________________ Click here to unsubscribe <mailto:[email protected]?body=SIGNOFF%20openmrs-implement-l> from OpenMRS Implementers' mailing list _________________________________________ To unsubscribe from OpenMRS Implementers' mailing list, send an e-mail to [email protected] with "SIGNOFF openmrs-implement-l" in the body (not the subject) of your e-mail. [mailto:[email protected]?body=SIGNOFF%20openmrs-implement-l]
