Trying to evaluate if one list is contained in another

[manwithaplan]

I’ve got an Option Set called “sustainable attributes”, then I’ve got a data type called “Products” and it has a field for “sustainable attributes” and it’s a list.

Then I’ve got a custom state that is a list of selected sustainable attributes:

I’m trying to Do A Search For… Products where the “sustainable attributes” of the product are in the “Selected Sustainable Attributes”, but I’m getting errors. As far as I can tell, I am comparing two lists, so I should be ok, but obviously it’s not working!

Any documentation on seeing if one list is contained in another? Can I use the Option Set for this?

[NigelG]

Try and advanced filter … “Contains List”…

Bear in mind it is direction sensitive, so A may contain B but B may not contain A.

[manwithaplan]

It took me a few minutes to find Advanced Filter, but it’s what I was looking for. I knew it must be somewhere!

–> After doing the regular search, you add the :filter to the “Do a search” part.