delete data from org unit

Dear all,

Can someone help me on how do I delete all data from belonging to some orgunit using one statement?

Regards

Joao

Jo Joao,

You can try…

DELETE FROM datavalue_audit where sourceid = ???

DELETE FROM datavalue where sourceid = ???

which should delete all aggregate data for the orgunit with sourceid equal to ???

Obviously, you should be careful with any delete statement, and always make a backup of you database.

Regards,

Jason

···

On Thu, Jan 8, 2015 at 9:26 PM, Joao Mazuze Joao_Mazuze@chasssmt.com wrote:

Dear all,

Can someone help me on how do I delete all data from belonging to some orgunit using one statement?

Regards

Joao


This message may contain privileged and confidential information intended solely for the addressee. Please do not read, disseminate or copy it unless you are the intended recipient. If this message has been received in error, we kindly ask that you notify the sender immediately by return email and delete all copies of the message from your system.


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

Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049