Re: [Dhis2-devs] Reset DataSet completeness to zero - DHIS2 2.25
Hello Jason, Thank you for your support! Regards, *Tantely* On Wed, Nov 22, 2017 at 11:39 AM, Jason Pickering < jason.p.picker...@gmail.com> wrote: > If you have access to the backend database, you can just do something like > > DELETE FROM completedatasetregistration WHERE ... (put your conditions > here); > > using one of these paramaters > > datasetid | integer | not null > periodid | integer | not null > sourceid | integer | not null > attributeoptioncomboid | integer | not null > > > Otherwise, use the API for this as described here: > > https://docs.dhis2.org/master/en/developer/html/webapi_complete_data_set_ > registrations.html#webapi_uncompleting_data_sets > > Regards, > Jason > > > On Wed, Nov 22, 2017 at 8:49 AM, Raminosoa Rabemanantsoa, Tantely < > tramino...@mikolo.org> wrote: > >> Dear DHIS2 community, >> >> I would like to ask if there is a way to reset report completeness to 0 >> (zero) in a bulk manner for some group of OrgUnit, via SQLView or Web API? >> We know the Orgunit uid, period and DataSet uid to reset. >> >> Thank you already for your suggestions! >> >> Regards, >> >> Tantely. >> >> *This message and its attachments are confidential and solely for the >> intended recipients. If received in error, please delete them and notify >> the sender via reply e-mail immediately.* >> ___ >> Mailing list: https://launchpad.net/~dhis2-devs >> Post to : dhis2-devs@lists.launchpad.net >> Unsubscribe : https://launchpad.net/~dhis2-devs >> More help : https://help.launchpad.net/ListHelp >> >> > > > -- > Jason P. Pickering > email: jason.p.picker...@gmail.com > tel:+46764147049 <+46%2076%20414%2070%2049> > -- *This message and its attachments are confidential and solely for the intended recipients. If received in error, please delete them and notify the sender via reply e-mail immediately.* ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-devs] Reset DataSet completeness to zero - DHIS2 2.25
If you have access to the backend database, you can just do something like DELETE FROM completedatasetregistration WHERE ... (put your conditions here); using one of these paramaters datasetid | integer | not null periodid | integer | not null sourceid | integer | not null attributeoptioncomboid | integer | not null Otherwise, use the API for this as described here: https://docs.dhis2.org/master/en/developer/html/webapi_complete_data_set_registrations.html#webapi_uncompleting_data_sets Regards, Jason On Wed, Nov 22, 2017 at 8:49 AM, Raminosoa Rabemanantsoa, Tantely < tramino...@mikolo.org> wrote: > Dear DHIS2 community, > > I would like to ask if there is a way to reset report completeness to 0 > (zero) in a bulk manner for some group of OrgUnit, via SQLView or Web API? > We know the Orgunit uid, period and DataSet uid to reset. > > Thank you already for your suggestions! > > Regards, > > Tantely. > > *This message and its attachments are confidential and solely for the > intended recipients. If received in error, please delete them and notify > the sender via reply e-mail immediately.* > ___ > Mailing list: https://launchpad.net/~dhis2-devs > Post to : dhis2-devs@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp > > -- Jason P. Pickering email: jason.p.picker...@gmail.com tel:+46764147049 ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
[Dhis2-devs] Reset DataSet completeness to zero - DHIS2 2.25
Dear DHIS2 community, I would like to ask if there is a way to reset report completeness to 0 (zero) in a bulk manner for some group of OrgUnit, via SQLView or Web API? We know the Orgunit uid, period and DataSet uid to reset. Thank you already for your suggestions! Regards, Tantely. -- *This message and its attachments are confidential and solely for the intended recipients. If received in error, please delete them and notify the sender via reply e-mail immediately.* ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
