GetFieldSelections eqvivalent for Possible Values?

[#1]

If I've got a listbox for OrderID I Can access the order ID that ive choosen via getFieldSelections. At the same time when I choose an order ID i will filter down the listbox containing OrderDate so that it only holds one possible value. Since I haven't explicitly selected that OrderDate in the listbox I can't use getFieldSelections() to get the order date. Any ideas how to get the date so that I for example can store it in a variable.

best regards

[erichshiino · Accepted solution]

Hi,

you can use:

Concat ( distinct OrderID, ',') where ',' is a separator for the field values

Regards,

Erich

[#3]

Thanks for replying!

I can't actually make it work, got a listbox named SalesOrderNumber and made selections in other listboxes so that SalesOrderNumber holds 4 possible values. Created a text object with expression:

=Concat(DISTINCT SalesOrderNumber, ',');

The text object just shows "-". Ideas?

[#4]

My bad, I've added a semicolon at the end of the line by habbit, It works great, thanks Erich!