···
On Tue, May 5, 2015 at 4:25 PM, Knut Staring knutst@gmail.com wrote:
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@gmail.com 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@micromerger.com wrote:
If from API. then how any further steps?
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
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
On Tue, May 5, 2015 at 3:29 PM, Knut Staring knutst@gmail.com wrote:
Probably only through the API or directly in the database.
–
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@micromerger.com 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
On Tue, May 5, 2015 at 2:01 PM, Muhammad Bilal Siddqui m.bilalsiddqui@micromerger.com 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@micromerger.com 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@lists.launchpad.net
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@micromerger.com 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