dhis2-devs team mailing list archive
-
dhis2-devs team
-
Mailing list archive
-
Message #38307
Re: Batch lock exceptions
Also, while I am at it, I wonder why we need the "lockexceptionid" at all
on the lockexception table? Isn't organisationunitid/periodid/datasetid
enough as a primary key? What is the need for this integer primary key?
Regards,
Jason
On Wed, Jul 1, 2015 at 8:30 AM, Jason Pickering <jason.p.pickering@xxxxxxxxx
> wrote:
> Managed to find this rather old message and had a question.
>
> I need to generate a large number of lock exceptions, and using the UI has
> a couple of issues.
>
> 1) I need to select certain children of a given parent, which actually are
> assigned to the data set. However, when I select the top level node, I can
> filter on OU group, but cannot filter on the actual data set assignment
> itself. I only see data sets which belong to the top level node, rather
> than ALL possible datasets which I may need to generate lock exceptions
> for.
>
> 2) I looked in the docs, but did not see any way to use the API to
> generate these lock exceptions in bulk. Is there a way to do this? Seems
> that I could in theory use the dhis-web-maintenance-dataadmin/addLockException.action
> to do this, but with several tens of thousand lock exceptions which needs
> to be generated, this does not seem particular efficient.
>
> I suppose the alternative is to use inject the SQL into "lockexception",
> but maybe there is an easier way?
> Regards,
> Jason
>
>
> On Thu, Jun 28, 2012 at 9:13 PM, Abhijeet . <abhijeet.7777@xxxxxxxxx>
> wrote:
>
>> hi
>> selecting multiple period at a time is a good idea..
>>
>> On Thu, Jun 28, 2012 at 6:21 PM, Olav <op.registrering@xxxxxx> wrote:
>>
>>> Hi,
>>> just a thought on improving the lock exception: it would be good if it
>>> was possible to make exceptions for several datasets for several months at
>>> the same time. Liberia want to use the locking to increase the focus on
>>> timeliness, but it turns out even allowing one facility to enter a few
>>> months backlog is a lot of work.
>>>
>>> What if you first select period type, then one or more datasets, and
>>> finally one or more periods?
>>>
>>> Olav
>>>
>>> _______________________________________________
>>> 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
>>>
>>
>>
>>
>> --
>> Regards,
>>
>> * Abhijeet*
>>
>> _______________________________________________
>> 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
>
--
Jason P. Pickering
email: jason.p.pickering@xxxxxxxxx
tel:+46764147049
Follow ups
References