dhis2-devs team mailing list archive

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

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


-- 
Jason P. Pickering
email: jason.p.pickering@xxxxxxxxx
tel:+46764147049