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 <[email protected] > 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 . <[email protected]> > wrote: > >> hi >> selecting multiple period at a time is a good idea.. >> >> On Thu, Jun 28, 2012 at 6:21 PM, Olav <[email protected]> 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 : [email protected] >>> Unsubscribe : https://launchpad.net/~dhis2-devs >>> More help : https://help.launchpad.net/ListHelp >>> >> >> >> >> -- >> Regards, >> >> * Abhijeet* >> >> _______________________________________________ >> Mailing list: https://launchpad.net/~dhis2-devs >> Post to : [email protected] >> Unsubscribe : https://launchpad.net/~dhis2-devs >> More help : https://help.launchpad.net/ListHelp >> >> > > > -- > Jason P. Pickering > email: [email protected] > tel:+46764147049 > -- Jason P. Pickering email: [email protected] tel:+46764147049
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
