← Back to team overview

dhis2-users team mailing list archive

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

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:



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

Follow ups