How to show location in Visit Report

Software Bahmni
,
1

Do we need to create a visit attribute, and then display the column using:

     "visitAttributes": ["Visit Location"]

I am having problems setting this attibute to automatically be the location.

2

Here are the 2 visit reports we’d like to include the visit location in

    "visitReport": {
    "name": "Visit",
    "type": "visits",
    "config": {
        "visitAttributes": ["Visit Location"],
        "patientAddresses": ["city_village"],
        "patientAttributes": ["impl.other","impl.phoneNumber"],
        "additionalPatientIdentifiers": ["impl.legacyId"],
        "ageGroupName":"",
        "excludeColumns": ["Date stopped", "Date Of Admission", "Date Of Discharge", "Visit Type", "New patient visit"]
    }
},
"pivotReportOfVisits": {
    "name": "VisitTotal",
    "type": "aggregation",
    "config": {
        "report":{
            "type": "visits",
            "config": {
                "forDataAnalysis": true,
                "visitAttributes": [                       
                ],
                "patientAddresses": ["city_village"],
                "patientAttributes": ["impl.other"],
                "additionalPatientIdentifiers": ["impl.legacyId"],
                "ageGroupName":"All Ages", 
                "visitTypesToFilter": []
            }
        },
        "rowGroups": [
            "Gender"
        ],
        "columnGroups": [
            "city_village","impl.other"
        ],
        "distinctGroups": [
            "Patient Identifier"
        ],
        "showTotalRow":true,
        "showTotalColumn":true
    }
},
3

I’ve realised the visitAttributes are only for admission status and visit status, we really need a way to display by location to avoid patients from separate locations being mixed up.

4

“Display by location” - in the queues?

5

In reports, for example we want a visit report just for the current location. If possible we would also like to search in registration app for patients with visit at the current location in a date range.

6

Showing the visit location (visit.location_id) should be easy enough in reports.

For searching in reg app, we need to build the feature and importantly need to think about UX.

7

Is there an example SQL query somewhere we can adapt which includes visit.location_id for a basic visit report based on location?

8

Has anyone been able to display reports per location using the standard Bahmni reports, i.e. without using SQL?

We would like to use the “aggregation” type report to summarize visits for the currently logged location, ideas?

    "pivotReportOfVisits": {
    "name": "VisitTotal",
    "type": "aggregation",
    "config": {
        "report":{
            "type": "visits",
            "config": {
                "forDataAnalysis": true,
                "visitAttributes": [  ],
                "patientAddresses": ["city_village"],
                "patientAttributes": ["impl.patientStatus"],
                "additionalPatientIdentifiers": ["impl.legacyId"],
                "ageGroupName":"All Ages",
                "visitTypesToFilter": []
            }
        },
        "rowGroups": [   "Gender","All Ages" ],
        "columnGroups": [    "city_village","impl.patientStatus"],
        "distinctGroups": [ "Patient Identifier" ],
        "showTotalRow":true,
        "showTotalColumn":true
    }
},
9

how do I display “visit.location_id” in this report?

10

I meant, including the “visit.location_id” in the results. I am not sure if we are even querying for the field.

11

Is it possible with the above report of type “visits” to display the location_id in the results?