I was trying to use the Contains filter with a value containing a '%' char in hte middle of value but no success. The settings are:
- The columns are generated programatically
What I'm trying to filter is something like:
([description] like '%apple%juice%') to bring values like "green apple juice" or "apple juice box" or even "yadda apple whatever juice" (sorry for the bad example)
The filter expression when I enter "apple%juice" in the filter item is generated like that example but the filter doesn't work. Is this approach possible or simply can't be done?