DHIS2Report SQL Query Enhancements
- Sri Maurya Kummamuru
Analytics
DHIS2Report SQL Query Enhancements
Primary mentor | @Sri Maurya Kummamuru |
Backup mentor | @James K |
Assigned to |
|
Abstract
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.
Project Champions
@Bob Jolliffe
@James K
Objectives
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() with SQL enhancements to be able to use either of those for specific queries.
Resources
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/