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]
