Hi everyone,
I’d like to know which table in DHIS2 contains data. To be more specifc, where can I found all the data captured by users in data set, event and tracker program.
Thanks in advance.
Hi everyone,
I’d like to know which table in DHIS2 contains data. To be more specifc, where can I found all the data captured by users in data set, event and tracker program.
Thanks in advance.
Hello @Lanja
here is an attempt to answer :
DataSet = datavalue , datavalueaudit
Tracker = trackedentityinstance, trackedentityattributevalue , trackedentityattributevalueaudit , programinstance, programstageinstance
Event = programstageinstance
I remind you that I only listed the main tables
Regards
Thanks! @didate! (:
Another user once asked for the DB schema which I think you might find interesting: Database Scheme of DHIS2 Tracker - #5 by jaime.bosque
Additionally, another approach would be to check out the api resources. For example in DHIS 2 Demo - Sierra Leone (after logging in): https://play.dhis2.org/2.37.0/api/resources