dhis2-devs team mailing list archive
-
dhis2-devs team
-
Mailing list archive
-
Message #33496
Re: how to delete data value
Thank you
From: Jason Pickering
Sent: Tuesday, October 14, 2014 2:38 Evening
To: channara rin
Cc: DHIS 2 Developers list, DHIS 2 Users list
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
References