Hi Darius, Thanks for that. I will get started on that immediately. Ketta
On Sat, Feb 25, 2012 at 10:18 PM, Darius Jazayeri <[email protected]>wrote: > Hi Ketta, > > And you could probably take that same SQL and put it in a > SqlDataSetDefinition in the reporting module. > > -Darius > > > On Sat, Feb 25, 2012 at 7:01 AM, Ketta Levi Martin <[email protected]>wrote: > >> Hi James, >> Thanks alot for that. I will work around it. >> >> >> >> On 2/24/12, James Arbaugh <[email protected]> wrote: >> > 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] >> > >> >> >> -- >> Martin Levi Ketta >> P.O. Box 1292 >> Masaka - Uganda >> Mob: +256 752808383 >> >> _________________________________________ >> >> 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] >> > > ------------------------------ > Click here to > unsubscribe<[email protected]?body=SIGNOFF%20openmrs-implement-l>from > OpenMRS Implementers' mailing list -- Martin Levi Ketta P.O. Box 1292 Masaka - Uganda Mob: +256 752808383 _________________________________________ 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]
