dhis2-devs team mailing list archive

[Muhire Andrew <muhireandrew@xxxxxxxxx>]

Great, thanks Ola for the clarification.

On Mon Sep 12th, 2011 11:58 AM PDT Ola Hodne Titlestad wrote:

>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
>>
>>