Have you implemented OpenMRS? Please participate in the Implementation Site Survey. If you already have, thank you!
Child pages
  • DHIS2Report SQL Query Enhancements
Skip to end of metadata
Go to start of metadata

DHIS2Report SQL Query Enhancements

Primary mentor

Sri Maurya Kummamuru

Backup mentor

James Kariuki

Assigned to



 Presently the module is relying upon creation of SQL Queries to be written for report data to be generated. This project aims at making that process smoother by creating tags of SQL queries and the ability to use them recursively for future SQL queries.

DRM-2 - Getting issue details... STATUS

Project Champions


  • Design the Model to
  • Create a reusable SQL query layer that will allow the users to create new queries based on pervious queries.
  • Create Documentation on the Proper usage of the module

Extra Credit

  • Integrate reporting module enhancements( DRM-3 - Getting issue details... STATUS ) with SQL enhancements to be able to use either of those for specific queries.



Present Project Wiki: https://wiki.openmrs.org/display/docs/DHIS+Report+Module+-+SHR+Customized+Version
Github codebase: https://github.com/hispindia/dhisreport/tree/ADX
Project Tickets: https://issues.openmrs.org/browse/DRM/

  • No labels