What tables do you need to update so that a dataset is marked as complete in the data entry application.
I have added entries in completedatasetregistion which then correctly shows the datasets as complete in the analytics, but the dataset still shows as incomplete in the data entry app.
I assume I am missing some other table but I am stumped as to which one.
This is an interesting question. Are you using pgadmin?
It would be interesting if it is possible to view ‘latest change’ in a database and what one could do is run a test by select a dataset as complete to view all the tables that were updated at the same time, but I’m not sure if that it’s possible?
I am sure it is possible to do what you are suggesting, but my knowledge of postgres does not extend that far.
I am using PG admin yeah. I cannot see anything obvious in the pgadmin dashboard.
I know in MS SQL you can view all the sessions and what queries they are running. Usually I would interrogate that if I was trying to work this out.
Edit:
Looks like PG admin has something similar. I will see if I can work it out from here and will report back.
I guess as a final, follow up question, is it possible to automate the completion of datasets within DHIS2? If I can avoid custom procedures or api calls that would be ideal.