dhis2-users team mailing list archive

[Dapo Adejumo <dapsyjorge@xxxxxxxxx>]

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" <gerald17006@xxxxxxxxx>
To: "Dapo Adejumo" <dapsyjorge@xxxxxxxxx>
Cc: "dhis2-devs" <dhis2-devs@xxxxxxxxxxxxxxxxxxx>, "dhis2-users" <dhis2-users@xxxxxxxxxxxxxxxxxxx>
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" < dapsyjorge@xxxxxxxxx > 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" < gerald17006@xxxxxxxxx > 
To: "dhis2-users" < dhis2-users@xxxxxxxxxxxxxxxxxxx >, "dhis2-devs" < dhis2-devs@xxxxxxxxxxxxxxxxxxx > 
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@xxxxxxxxxxxxxxxxxxx 
Unsubscribe : https://launchpad.net/~dhis2-devs 
More help : https://help.launchpad.net/ListHelp