Repo Owner: Ben Guaraldi @benguaraldi
The SQL Viewer app offers a user-friendly viewing experience for SQL views and SQL queries in DHIS2, allowing for variable entry, search within query results, and column sorting.
- Install the app via the App Hub or by uploading into the DHIS2 App Management app the zip either from our releases or from
yarn build - Users need to be granted access to the app in order to be able to access it. To do this, go to DHIS2 Users > User role > [role] > Apps > select
SQLViewer app. Make sure to do this on any roles for which you want users to have access to SQL Viewer. Note that access to individual SQL Views and SQL Queries as well as the underlying data is governed by the sharing of the underlying objects. Granting a user access to the SQL Viewer App allows a user access to the app to view item they already have access to.
- Fork or clone repo
- Install all dependencies with
yarn install - Run locally with
yarn start(When starting for the first time, you will be prompted to provide information on your server and login credentials. SQL Viewer App is built with the DHIS2 App Platform, and you can find more information for troubleshooting on the DHIS2 APP Platform website ) - Build for production locally with
yarn build
Please create an issue or a pull request.