I would like to filter a field after comparing it to a variable.
The variable value is only a part of the field value, that is why I would like to use the "LIKE ‘% … %’ function.
I tried to define ‘% and %’ as wrapping characters for the variable
I also tried to write ‘% and %’ manually in the component filter formula.
( FILTER “TABLE”.“FIELD” LIKE ‘% <%=VAR%> %’; )
None of these worked. Is there a solution for this?
Thank you very much for your help,