Hi
What is the best approach to deleting an organisation unit that has been used to enter data program across various programs and data sets.
Hi
What is the best approach to deleting an organisation unit that has been used to enter data program across various programs and data sets.
Can you perhaps just set it its closed date? This will preserve all data and details about the org unit.
Hi. That is possible. But I’m talking of a case of duplicate org units and one needs to go
Try this found here: https://github.com/dhis2/dhis2-utils/blob/master/resources/sql/delete_orgunit_with_data.sql
Hi,
I have deployed 2.35 on my server, is there any new approach to removing Organizational Units with NO DATA and ALL CHILDREN removed? I see a query on github but it’s from 2018? Does this still apply?
Hi @Jerome.S , the approach is still the same, some tables like 'DELETE FROM trackedentitydatavalue
no longer exist so you may need to alter the script a bit.