Hi Gerald, You can run this command in the db - DELETE FROM datavalue WHERE sourceid = 'XXXXX';
Replace XXXXX with the orgunit id. Hope that helps. ……………………………………… Regards, Dapo Adejumo +2348033683677 Skype : dapojorge ----- Original Message ----- From: "gerald thomas" <gerald17...@gmail.com> To: "Dapo Adejumo" <dapsyjo...@gmail.com> Cc: "dhis2-devs" <dhis2-devs@lists.launchpad.net>, "dhis2-users" <dhis2-us...@lists.launchpad.net> Sent: Thursday, October 1, 2015 5:39:25 PM Subject: Re: [Dhis2-devs] Removing Organization Units Dear Dapo, What is the command to remove those data from the database as per organisation unit? Please help me. Regards, Gerald On Oct 1, 2015 16:16, "Dapo Adejumo" < dapsyjo...@gmail.com > wrote: Hi Gerald, What error are you getting? If you have data associated with these org units, you will not be able to remove them until you delete the data in the database (even if you have removed the datasets). ……………………………………… Regards, Dapo Adejumo +2348033683677 Skype : dapojorge ----- Original Message ----- From: "gerald thomas" < gerald17...@gmail.com > To: "dhis2-users" < dhis2-us...@lists.launchpad.net >, "dhis2-devs" < dhis2-devs@lists.launchpad.net > Sent: Thursday, October 1, 2015 5:10:25 PM Subject: [Dhis2-devs] Removing Organization Units Dear All, I am trying to remove Organisation Units from DHIS2 versions 2.18 and 2.20 but i am getting error. But i had already removed the datasets associated with these Organisation Units but i still can't remove them. Please can someone help. -- Regards, Gerald _______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp _______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp