Page 1 of 1
jBPM Workflow: Form Element 'SELECT' get data 'group admin'
PostPosted:Wed Dec 04, 2013 9:03 am
by shrek258
Defined form in forms.xml workflow in select element, I want to use group (ROLE_ADMIN) data, rather than select optionsQuery = "select $ * from DatabaseMetadata". Is there any way? Or I can go directly to "select ur_user from OKM_USER_ROLE where ur_role = 'ROLE_ADMIN' " rather than get data from OKM_DB_METADATA_VALUE table?
Re: jBPM Workflow: Form Element 'SELECT' get data 'group ad
PostPosted:Fri Dec 06, 2013 9:12 am
by jllort
At this moment are not allowed free queries, only based on metadata tables. We've planned extend it, but is still not done.
Re: jBPM Workflow: Form Element 'SELECT' get data 'group ad
PostPosted:Sun Dec 08, 2013 11:47 am
by shrek258
jllort wrote:At this moment are not allowed free queries, only based on metadata tables. We've planned extend it, but is still not done.
Thank You! ^-^
Re: jBPM Workflow: Form Element 'SELECT' get data 'group ad
PostPosted:Fri Apr 11, 2014 5:03 am
by matt81
Hi,
Is it allowed now to make free sql queries without using metadata tables. Has it been enabled now??
Re: jBPM Workflow: Form Element 'SELECT' get data 'group ad
PostPosted:Sun Apr 13, 2014 2:19 pm
by jllort
Still going only with metadata tables, althought is easy to extend it, it's already thinked. The idea will be a new attribute name with Class what implements some interface. Extend the dtd and not much. The problem we got is still we've not found time to doing it. If some customer has been demanded it, sure will be implemented but actually our roadmap is full and has not been posible to add this feature like others also interesting.
With the solution I provide to you, can take source code and do it, we'll be pleased add in default community core.