dhis2-users team mailing list archive

[Jason Pickering <jason.p.pickering@xxxxxxxxx>]

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@xxxxxxxxxxxx>
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@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Jason P. Pickering
email: jason.p.pickering@xxxxxxxxx
tel:+46764147049