Hey,
I’m currently building a explore which contains a concatenated string as a key. I would like to be able to filter based on this string where I have 2-4 unique substrings that it must contain. This would equate to an AND contains while I can only seem to make OR contains filters.
The sql equivalent of what I was to achieve looks a little like this:WHERE (key_string LIKE ‘SUBSTRING_1’ AND key_String LIKE ‘SUBSTRING_2’)