Bahmni Visit Report Customization

I need some help on generating visit report with confirmed diagnosis on each patient. Currently I can see Outpatient Morbidity report, however it summarized the diagnosis based on gender.

I’d like to see list of patients as well as with the diagnosis given. How can I customize the sql to achieve that (The sql seems pretty complex to me) ?

Hi Mustafa, This is a custom sql diagnosis report that i had written. See if it works for you. It does’t consider the attributes like Presumed/Confirmed , Primary/Secondary. If it doesn’t work as is, it could act as a starting point

The concept ids are hardcoded, you might want to update them as per your implementation or remove the hardcoding.

1 Like