Re: [Dhis2-users] SQL view question

Thank you very much everyone, for your guidance. I don't have a copy of the database locally. That actually is a good idea and I will do that. If I have any problems, I'll email. Regards, Angela Get Outlook for iOS On Thu, Aug 25, 2016 at 8:13 AM -0400, "David Mut

Re: [Dhis2-users] SQL view question

Hi Angela, Its usually easier to write the queries using a copy of the database stored locally and using the database access tools described above, test them before copying them over to the SQL VIEW for front end access using dhis2, one is able to easily troubleshoot any errors in the scripts and f

Re: [Dhis2-users] SQL view question

Hi Angela, You will need to access the database, ideally having a local copy on your laptop and using GUI tools i.e. Pgadmin, Navicat for PostgresSQl or other tools will allow you to access the backend. From there the names for the tables can serve as a guide e.g. datalement for dataelements, datas

Re: [Dhis2-users] SQL view question

Hi, 1) The SQLView feature is basically just a convenient way to expose the database directly, meaning you query the database tables with straight SQL statements. Unfortunately there's no documentation detailing names of tables and columns in the DB, so you'll have to look them up in an instance o

Re: [Dhis2-users] SQL view question

Hi I have not used the SQL view before and after perusing the documentation, I am still not clear on 1. Which name references are to be used in the SQL statement for the elements and table? My current element names and short names used by the forms have spaces 2. Using the web.ap