dhis2-devs team mailing list archive

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

Thanks Morten. Have created the blueprint here

https://blueprints.launchpad.net/dhis2/+spec/lock-exceptions-api

Regards,
Jason


On Wed, Jul 1, 2015 at 9:29 AM, Morten Olav Hansen <mortenoh@xxxxxxxxx>
wrote:

> Jason
>
> Create a blueprint for lock exception API, and I will have a look at it..
> can't promise it for 2.20 though.
>
> I agree it might be better to have it as a composite key, but these have a
> tendency to create havoc with our generic importer, so lets convert it to a
> idObject and keep it as it is for now.
>
> --
> Morten
>
> On Wed, Jul 1, 2015 at 1:39 PM, Jason Pickering <
> jason.p.pickering@xxxxxxxxx> wrote:
>
>> 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
>>
>> _______________________________________________
>> 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