dhis2-devs team mailing list archive

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

Hi Channara,
There is no easy way to do this through the user interface, However, you
can run the following SQL statement if you want to delete all of your data.

-----WARNING----
If you execute these statements, you will delete all of your data,
irrevocably, so be sure you have a back up in case you might need to
recover it.
-----------------------

TRUNCATE datavalue_audit;
TRUNCATE datavalue;

Regards,
Jason


On Tue, Oct 14, 2014 at 4:19 AM, <rin.channara@xxxxxxxxx> wrote:

>  Hi all Dhis2,
> I want to delete data value all every month or quarter. how can I delete
> them?
>
> Thank you
> CHANNARA
>
> _______________________________________________
> 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