Include Medication in the report

jess · September 4, 2024, 4:07pm

Hi, i would like to put the drug registered in medication Tab inside the report. Do you have any idea on how to do it?

Need help please. Thank you

gsluthra1 · October 5, 2024, 5:24am

Try this:

Bahmni/standard-config/blob/master/openmrs/apps/reports/reports.json#L121


      
              "patientAttributes": [
                "phoneNumber"
              ],
              "conceptNames": [
                "Height (cm)",
                "Weight (kg)"
              ],
              "filterBy": "Date of Discharge"
            }
          },
          "OrderFulfillmentReport": {
            "name": "Order Fulfillment Report",
            "type": "OrderFulfillmentReport",
            "requiredPrivilege": "app:reports",
            "config": {
              "type": "OrderFulfillmentReport",
              "orderTypes": [
                "Order",
                "Drug Order"
              ]
            }

or this:

github.com

Bahmni/standard-config/blob/master/openmrs/apps/reports/reports.json#L121


      
              "patientAttributes": [
                "phoneNumber"
              ],
              "conceptNames": [
                "Height (cm)",
                "Weight (kg)"
              ],
              "filterBy": "Date of Discharge"
            }
          },
          "OrderFulfillmentReport": {
            "name": "Order Fulfillment Report",
            "type": "OrderFulfillmentReport",
            "requiredPrivilege": "app:reports",
            "config": {
              "type": "OrderFulfillmentReport",
              "orderTypes": [
                "Order",
                "Drug Order"
              ]
            }

gsluthra1 · October 5, 2024, 5:24am

Alternatively, you can try writing direct SQL. e.g: