← Back to team overview

dhis2-devs team mailing list archive

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