dhis2-devs team mailing list archive

[Ola Hodne Titlestad <olati@xxxxxxxxxx>]

Hi,

The only two commands you should run on your database are the two delete
statements;
delete from datavalue_audit where dataelementid=<id>;
delete from datavalue where dataelementid=<id>;

"Replace" is not a command, just Lars telling you to change the <id> in the
two commands above with the real IDs of your data elements.

Seems all is fine then. You can now try deleting the data elements from the
DHIS 2 user interface.

Ola
------

----------------------------------
Ola Hodne Titlestad (Mr)
HISP
Department of Informatics
University of Oslo

Mobile: +47 48069736
Home address: Vetlandsvn. 95B, 0685 Oslo, Norway. Googlemaps
link<http://maps.google.com/maps?f=q&source=s_q&hl=en&geocode=&q=Vetlandsvn.+95B,+0685+Oslo,+Norway>


2011/9/12 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
>
>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-users
> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>