I am trying to compose an indicator which makes use of a join with a custom table.
Does anyone have an idea why executing the query directly as: mysql -u ... -e 'Select count(patient.patient_id) from patient inner join opd_patient_queue_log on patient.patient_id=opd_patient_queue_log.patient_id' results in 16593, but when I create a sql cohort query as above (without the count), I get a result of 13592. How does openmrs count the size of the resultset? It seems its not a simple count ... Regards Bob _________________________________________ To unsubscribe from OpenMRS Developers' mailing list, send an e-mail to [email protected] with "SIGNOFF openmrs-devel-l" in the body (not the subject) of your e-mail. [mailto:[email protected]?body=SIGNOFF%20openmrs-devel-l]
