List of all patients

Ask OpenMRS
1

Hi community, please do we have a way to get the list of all registered patients in system in order to get the number.

Thank you.

2

Hey @jess , you can configure reports to get all the registered patients.

3

@gokul thank you to reply

image
image1920×1080 148 KB

Is it not possible to get them, in the clinical, when go to all. get the list of all the registered patient with number in order to know the Total patients @gsluthra may you help, any idea?

4

Please type % and press Search. That usually lists all the patients.

5

@gsluthra unfortunately it does not display all patients, is it not possible to display it like this like described here https://bahmni.atlassian.net/wiki/spaces/BAH/pages/37945497/Patient+Lists but it is not clearly explain on how to do it.

image
image1280×508 110 KB

Thank you.

6

I tried this out here: https://docker.lite.mybahmni.in/bahmni/clinical/index.html#/default/patient/search

And I entered “%” and I could see all patients listed (40+). Not sure if there is an upper limit on no. of patients returned. You want an ALL patient list screen that lists all patients? That would have a performance impact.

7

@gsluthra i see i understand, please do we have a way to know the number of patient enteredin the system. Thank you

8

You can use a SQL Report (Select count(*) from Patient table) https://bahmni.atlassian.net/wiki/spaces/BAH/pages/2270265367/Reporting+Overview+Bahmni#ReportingOverview(Bahmni)-3.CustomSQL

9

@gsluthra i have tried it and here is the configuration:
“hospitalActivities”: { “name”: “Hospital Activities - Number of Clients Served (New and Total)”, “type”: “obsCount”, “config”: { “sqlPath”: “/var/www/bahmni_config/apps/openmrs/reports/sql/number_of_clients.sql” } } the report does not appear, @mohant can you help also please.

Thank you.

10

It should be in reports.json.("type":"MRSGeneric") See this: