← Back to team overview

dhis2-devs team mailing list archive

Re: Dear Dhis2 users how can i delete?

 

As a rule of thumb, it is usually wise to do a SELECT before a DELETE, so
that you are 100% sure you are not deleting data you really need.

In this case:

select * from datavalue_audit where dataelementid=<id>;
select * from datavalue where dataelementid=<id>;

Knut

2011/9/12 Lars Helge Øverland <larshelge@xxxxxxxxx>

> 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-devs
> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>



-- 
Knut Staring
Informatics, U. of Oslo
http://hisp.uio.no
+4791880522

Follow ups

References