dhis2-users team mailing list archive

[Jason Pickering <jason.p.pickering@xxxxxxxxx>]

Hi Muhammad,
You might want to try something like

DELETE FROM datavalue where dataelementid in (SELECT DISTINCT dataelementid
from datasetmembers where datasetid = XXXX);

where XXXX is the datasetid (the numeric ID) of your data set.

Or some variant there of....

Of course, you should be really sure that you want to do this, and that you
make a backup. But this is probably the quickest way.

Regards,
Jason


On Tue, May 5, 2015 at 2:36 PM Muhammad Bilal Siddqui <
m.bilalsiddqui@xxxxxxxxxxxxxxx> wrote:

> If from API. then how any further steps?
>
> On Tue, May 5, 2015 at 3:29 PM, Knut Staring <knutst@xxxxxxxxx> wrote:
>
>> Probably only through the API or directly in the database.
>>
>> On Tue, May 5, 2015 at 2:01 PM, Muhammad Bilal Siddqui <
>> m.bilalsiddqui@xxxxxxxxxxxxxxx> wrote:
>>
>>> I have some data sets from which i want to remove all entries that i did?
>>> is there any way for this?
>>>
>>> --
>>> --
>>> Regards
>>> *Muhammad Bilal Siddiqui*
>>>
>>> *MicroMerger IT Solutions*
>>> Suite # 731, Street # 20
>>> Sector I-8/2 Islamabad.
>>> Pakistan 44000
>>>
>>> *C* : +923325694928  *P* : +92514863592
>>> *E* : m.bilalsiddqui@xxxxxxxxxxxxxxx <m.haroon@xxxxxxxxxxxxxxx>  *W* :
>>> www.micromerger.com
>>>
>>>
>>> *This e-mail and any files transmitted with it are confidential to the
>>> intended recipient and may be privileged. If you are not the intended
>>> recipient, please immediately notify the sender. Whilst we have used
>>> Anti-Virus software to alert us to the presence of computer viruses, we
>>> cannot guarantee that this email and any files transmitted with it are free
>>> from them.*N : Think before print do you really need this on paper.
>>> thanks
>>>
>>> _______________________________________________
>>> 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
>>>
>>>
>>
>>
>> --
>> Knut Staring
>> Dept. of Informatics, University of Oslo
>> Norway: +4791880522
>> Skype: knutstar
>> http://dhis2.org
>>
>
>
>
> --
> --
> Regards
> *Muhammad Bilal Siddiqui*
>
> *MicroMerger IT Solutions*
> Suite # 731, Street # 20
> Sector I-8/2 Islamabad.
> Pakistan 44000
>
> *C* : +923325694928  *P* : +92514863592
> *E* : m.bilalsiddqui@xxxxxxxxxxxxxxx <m.haroon@xxxxxxxxxxxxxxx>  *W* :
> www.micromerger.com
>
>
> *This e-mail and any files transmitted with it are confidential to the
> intended recipient and may be privileged. If you are not the intended
> recipient, please immediately notify the sender. Whilst we have used
> Anti-Virus software to alert us to the presence of computer viruses, we
> cannot guarantee that this email and any files transmitted with it are free
> from them.*N : Think before print do you really need this on paper. thanks
>  _______________________________________________
> 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
>