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.muh...@moh.gov.rw
God is my provider.
________________________________
From: Lars Helge Øverland <larshe...@gmail.com>
To: Muhire Andrew <muhireand...@yahoo.com>
Cc: dhis2-d...@lists.launchpad.net; dhis2-users@lists.launchpad.net
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
_______________________________________________
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp
