List the patient by drug and disease

Ask OpenMRS
1

Application Name: Bahmni Version Number: 2.4 Question: I want to query (OpenMRS database )the following scenario,

I want to List all the patient who has some disease and takes some drug ( SQL Query)

Example: I want to List all the patient who has cancer disease and takes Metformin drug.

Output will be like:

Patient Disease Drug Sanne Cancer Metformin anne Cancer Metformin Janne Cancer Metformin

Please help me with this, Appreciate your help, Thanks a Lot :slight_smile:

2

Did you get a chance to look at this? https://wiki.openmrs.org/display/docs/Reporting+Module