List Filter Advanced

[anon94678708]

Hey there!

I’ve got a problem with filtering a repeating group by custom states.
The repeating group only should show Things that contain a specific category (Selected Template Categories is a custom state which is a list of an option set; Template Categories is a List of an option set).

Problem: the value right now is empty.

Thanks for help.

[williamtisdale]

As far as I know, it will not work if you say ListA ‘contains’ ListB. You have to either break it up and say ListB:item#1 is in ListA or ListB:item#2 is in ListA and so forth across all item numbers. Or you can say ListA contains ListB:item#1 and so forth until all item numbers are accounted for.

[luke2]

Hi,

You can use the ‘contains list’ expression or other use the ‘intersect with’ in this situation

Show if list A contains any item in list B

Hi everyone, I have looked through the forum to no avail. I’m basically trying to recreate a tinder pile because of a bug that has caused it to completely defeat its purpose. I need to show the profile of user B only if their criteria matches user A. The page shows 1 user per refresh only. I’ve got all but 2 of the filters sorted. Area and zones. Basically I want user B to show up as a profile if their area preference is ANY of user A’s. This seems like such an easy thing in a data perspect…

Issue with contains / intersect with list

Hi @lam, I updated your filter to do what you need. Check it out and let me know if you have any questions. If you use “intersect” it’ll look for any items that are in both lists of orders. You’ll see that I used an advanced filter to do this. The intersect operation returns the list of results, so as long as there is > 0 intersected orders, the user should show. Gaby | Coaching Bubble Private coaching, courses, and tons of free resources

[anon94678708]

Thank you, but the list changes dynamically in its length (i forgot to say). This approach would be suboptimal in the implementation.

[anon94678708]

Thank you very much! I used the ‘contains list’ expression and it worked perfectly.