DHIS2Report SQL Query Enhancements

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/