I am trying to use the WHERE parameter in the URL of my experience view
I have this part of my URL: data_filter=dataSource_1-198860de052-layer-7:Brands LIKE '%Pitman%'
Which after encoding looks like: data_filter=dataSource_1-198860de052-layer-7%3ABrands%2520LIKE%2520%27%2525pitman%2525%27
This works for entries where the full text of the Brands column is "Pitman", but not if it contains "Pitman" but also other text. Is it possible to make it actually do partial matching?
Thanks