12-13-2017 12:38 AM
how to get drop down data from database in alfresco workflow starting page.Like city name,country name anyone having idea how we will do in alfresco.
12-13-2017 12:49 AM
Are you talking about list constraint for your property of your workflow model? If not than please elaborate your question.
12-13-2017 01:09 AM
For the list constraint property in workflow model
12-13-2017 01:23 AM
Okay so you want the list constraint on your starting workflow page. Refer the tutorial of Jeff Potts on following link:
And configure your workflow model to list constraint to your property.
12-13-2017 01:27 AM
need to get those properties values from database to show in drop down.
12-13-2017 02:49 AM
Hope you get your solution from the discussion:
12-13-2017 02:54 PM
I am reluctant to populate list constraints in the data model from a database because if/when those records change, you will see constraint violations in your repository. However, if you want to do that, you can just write a custom list constraint class.
If the intent is that you want to have a dropdown that is populated from a database call, there are multiple ways to do that without requiring a custom list constraint.
For example, you could:
1. Write a custom form control and have the form control use an AJAX call to call an external (non-alfresco) service. The service will return the list of items for the dropdown. Where that service gets the list is up to you--it could be a database query.
OR
2. Write a custom form control that makes an AJAX call to a web script. That web script can query the database or some other external service for the dropdown items.
Either of these is probably better than writing a custom list constraint that makes a database call.
12-14-2017 09:12 AM
The following project can provide some good ideas, not using database as a source though:
Explore our Alfresco products with the links below. Use labels to filter content by product module.