← Back to team overview

dhis2-devs team mailing list archive

Entities enrolled in multiple programs

 

Hi everyone,

I am using tracker to manage community health data of around 30k patients
using 15 chronic disease programs + Maternal care program. Sometimes a
patient might be enrolled in more than 1 program.

Is it possible to generate a list of patients currently enrolled in a
program?
To make things more sophisticated, I have requirements to find the list of
patients who are enrolled in multiple programs. Also to find aggregate
numbers. Is it possible?

For example, I want to know the patients who are having HIV and TB.
And patients enrolled in Maternal care program who are also in HIV program.

Is there an out of the box report framework that I can use, or do I have to
create custom SQLs to get these details?

​Thanks in advance
,
- Arun Paul