dhis2-devs team mailing list archive

[Muhire Andrew <muhireandrew@xxxxxxxxx>]

Thanks for the quick help,
i have successfully used the select and delete steps(in datavalues and datavalue_audit) but using replace <id> is not working on my side may be am not using it well? please update me again (only replace syntax). i have deleted data from my data element x and next step was to use replace but am getting syntax error!
waiting for your help dear team!
 




________________________________



Muhire Andrew

HMIS/Ministry of Health
andrew.muhire@xxxxxxxxxx
God is my provider.



________________________________
From: Lars Helge Øverland <larshelge@xxxxxxxxx>
To: Muhire Andrew <muhireandrew@xxxxxxxxx>
Cc: dhis2-devs@xxxxxxxxxxxxxxxxxxx; dhis2-users@xxxxxxxxxxxxxxxxxxx
Sent: Monday, September 12, 2011 3:51 PM
Subject: Re: Dear Dhis2 users how can i delete?

Hi Andrew,

you need to remove the data with SQL in the database. Run:

delete from datavalue_audit where dataelementid=<id>;
delete from datavalue where dataelementid=<id>;

and replace <id> with the dataelementid of the one you want to remove.

You can then go ahead and delete the data element in the user interface.



Lars