Delete Org Unit

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.

1 Like

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

1 Like

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.

1 Like