On Button Click: Conditional Selection of Values

[PhilippZiemer]

Hello everyone,

I want to specifically select values on a condition, as soon as I press a button. I got two values to compare. I succeeded in selecting the set. But I couldn't find any suitable way to apply this set as search string to a field.

The set is given as following:

( { $<DATE = {"$(=Max(DATE))"}, INVENTORY_LAST_MOVEMENT = {">=50"}> } MATERIAL_ID )

Is there any way to concatenate this set to a string with "|" (e.g. ="MATERIAL_ID1" | "MATERIAL_ID2" | ...). Or is there a better work around to select these values via button click?

Thanks for any help

Philipp

[kumarnatarajan · Accepted solution]

Hi,

Try This

EX: '(' & Concat(DISTINCT { $<DATE = {"$(=Max(DATE))"}, INVENTORY_LAST_MOVEMENT = {">=50"}> } '"'&MATERIAL_ID&'"','|') & ')' 

[PhilippZiemer]

Thx, that was what I was looking for