dhis2-users team mailing list archive

[Knut Staring <knutst@xxxxxxxxx>]

It is a lot easier to do this directly in the database the way Jason
indicated, because doing it through the Web API would require specifying
each combination of orgunit, dataelement and period, as described here (at
least I think that would be required - happy to be taught otherwise):

https://www.dhis2.org/doc/snapshot/en/developer/html/ch01s10.html#d5e1561

Knut

On Tue, May 5, 2015 at 2:40 PM, Jason Pickering <jason.p.pickering@xxxxxxxxx
> wrote:

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


-- 
Knut Staring
Dept. of Informatics, University of Oslo
Norway: +4791880522
Skype: knutstar
http://dhis2.org