Key Database Tables to run sql scripts on

[fmwesigwa (Frank Mwesigwa)]

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.

[Gassim (AL-Gassim Sharaf Addin)]

Hi and welcome to the community @fmwesigwa

@fmwesigwa

data elements data value for the org unit for a specific period of time.

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 .

[fmwesigwa (Frank Mwesigwa)]

Thanks @Gassim. This is much helpful