Dropdown values from DB lookup

[prashantgadgil]

I have a dropdown in Activiti form in Alfresco Process Services.

Currently only two ways to populate the dropdown values are Manual and via a REST service.

Is there a way to populate the dropdown instead using a Java delegate before the form shows up?

e.g. by putting some JSON in execution.setVariable() which binds it to the ID of the dropdown field?

For each such dynamic dropdown, I don't always want to have to expose a REST service, if we already have a java delegate being used and avaialable before the human task in the process

Any ideas?

[cjose]

There is no such option now! Btw, since the topic says, "Dropdown values from DB lookup", are you storing your dropdown values in a DB? If you want to lookup from DB and populate the dropdown via a REST call see if this little DB to REST plugin via datamodel helps.

[prashantgadgil]

is there future enhancement planned around this from Alfresco to enhance APS? I am using lot of java delegates and task listeners to persist the data between Activiti tasks. so it may make sense to do DB query in java itself and populate json of the dropdown directly in the pre task listener class, just like I can do it for dynamic table. ... sounds like a relatively easy addition to the product?

[cjose]

I cannot speak for the roadmap. However data model feature in APS is a key part of the roadmap that can be used to persist and read data to and from external systems. So I would expect more data model integrations in form components such as drop downs in the future. As a customer/partner using APS, feel free to raise a feature request via your portal.

Ciju