Dropdown not showing data from BDM

Q&A
1

Hello,

I want to create a Dropdown, that Displays all the data from a Business Data ModelTable called “Customer”.
I created a custom querry to get all the IDs (called getAllIDs):
SELECT persistenceId FROM Customer

On my form I created a variable with the following external API:
../API/bdm/businessData/de.test.model.Customer?q=getAllIDs

In the Dropdown I selected then uses this vaiable in the “Available values” field and I enterd PERSISTENCEID as the “Displayed key”.

But I’m still not getting any values!?

Thanks!

2

Check out these posts…

http://community.bonitasoft.com/questions-and-answers/how-load-and-show-list-datas-data-base-select-item-data-base-connector-or

http://community.bonitasoft.com/questions-and-answers/get-selected-value-dropdown-list

http://community.bonitasoft.com/questions-and-answers/select-widget-does-not-take-returned-key-configuration

regards
Seán

PS: As this reply answers your question, please mark as resolved.

3

As far as I understand this:
First link has the same goal, but uses completly diffrent databases etc.
Second link doesn’t contain a solution.
Third link Looks great, but I’m still not getting any values and I think the problem is my external API call.