Problem with Select Widget and List of values

Q&A
1

 

I am using the Sql server connector to obtain data, the data is in a process variable that will be used in a select widget.

Instead of showing the items like this "Test" shows them like this:
"T
e
s
t "

How can I solve that?

My variable es called clients ../API/bpm/caseVariable/{{task.caseId}}/clients

In values I usded clients.value

clients.value returns this:
{"case_id":"35030","name":"clientes","description":"","type":"java.util.Collection","value":"[Client Additions or Withdrawals, No Money Exchanged, Mid Term Capital Distributions, Cash Account (US Dollar), Fund Reinvestment--Long Term Gains, Fund Reinvestment--Mid Term Gains, Fund Reinvestment--Short Term Gains, Fund Reinvestment--Dividends, Management Fee, Banco Bradesco SA]"}

These values are not client, change the query for confidentiality reasons.

2

Hello. Not very familiar with the caseVariable API, but your clients.value is a list inside a string, instead of a list of strings.

You can take the clients.value and convert it to a list of strings by doing something like this in a UID variable:

clients.value.replaceAll("[", "").replace("]", "").split(", ")

This will remove the [ and ] and then creates an array that contains the strings.

 

Hope this helps,

Dumitru