How to populate the Select Widget from external DB (MySQL)?

1
0
-1

Hi there,

I am new to Bonita. I am trying to populate the select widget with data from an external database (MySQL).
I created a connector in, Set the query, Created a Variable. The output of the query is already stored in the variable. In the UI design i am getting the resultes with the following REST API : ../API/bpm/caseVariable/{{task.caseId}}/example. I named this variable newVar/

The result comes as a variable. It has the name = EXAMPLE, description = "", type= "java.util.List", value: "[[iPhone 7, 01], [iPhone 8 , 02], [iPhone X, 04]]".
If I write newVar.value in the Avaliable Values, in return I get the following result:

[

[

i

P

h

o

n

e

0

1

....
...

All the items that coming in the value.

Can anyone tell me what am I doing wrong? I have tried to manipulate with the result but it does not work.

No answers yet.
Notifications