Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Try This
EX: '(' & Concat(DISTINCT { $<DATE = {"$(=Max(DATE))"}, INVENTORY_LAST_MOVEMENT = {">=50"}> } '"'&MATERIAL_ID&'"','|') & ')'
Hi,
Try This
EX: '(' & Concat(DISTINCT { $<DATE = {"$(=Max(DATE))"}, INVENTORY_LAST_MOVEMENT = {">=50"}> } '"'&MATERIAL_ID&'"','|') & ')'
Thx, that was what I was looking for