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.

Error rendering macro 'jira' : Unable to locate Jira server for this macro. It may be due to Application Link configuration.

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(
Error rendering macro 'jira' : Unable to locate Jira server for this macro. It may be due to Application Link configuration.
) 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/