← Back to team overview

dhis2-devs team mailing list archive

Re: 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.pickering@xxxxxxxxx> 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 <
> 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 <+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.*

References