dhis2-devs team mailing list archive

[Muhire Andrew <muhireandrew@xxxxxxxxx>]

Thanx Lars for the quick help.
 




________________________________



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