what are some of the key tables in the database that I can use to extract data from. I would like to create an sql script that returns data elements data value for the org unit for a specific period of time.
Hi and welcome to the community @fmwesigwa
I’d start with the related tables to your purpose. Use the sqlViews in the Maintenance app → Other → SQL Views, and create the query:
SELECT * FROM information_schema.tables which will list the available tables for you and then you could use keywords such as ‘dataelement’ using Ctrl+F .
Thanks @Gassim. This is much helpful