I have DHIS2 implementation that has some programs and events in it, which we want to clean in order to begin a fresh, the develop of events and tracker programs. The existing programs were done poorly and cleaning it will take time.
DHIS2 instance is version 2.32
Your help will be highly appreciated.
I found a potential script that can be used to delete these programs here:
I have a starting pont for you. The script has not been used in a while, and it is only tested with my one program - so expect that there is a relation or two that needs to be added before everything works. Obviously you need to change the script to delete your program, and not the program named ‘Some program’ as it is currently:
delete from program_attributes where programtrackedentityattributeid in(select pa.programtrackedentityattributeid from program p join program_attributes pa …
@Markus to see if he has any further input.
Did you have a chance to try the script?