Question

Filter string based on multiple contains

  • 27 July 2022
  • 0 replies
  • 13 views

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’)


0 replies

Be the first to reply!

Reply