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 <[email protected]> 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 : [email protected] > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp > > -- Jason P. Pickering email: [email protected] tel:+46764147049
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-users Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
