Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
you can use:
Concat ( distinct OrderID, ',') where ',' is a separator for the field values
Regards,
Erich
Hi,
you can use:
Concat ( distinct OrderID, ',') where ',' is a separator for the field values
Regards,
Erich
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?
My bad, I've added a semicolon at the end of the line by habbit, It works great, thanks Erich!