Matching two Lists

[conradaszen]

Hello Bubble Community! I have a problem with filtering my repeating group with another list. In the example below I’ll explain what I intend to do.

Basically two different data types:
-Materials

-Furniture(with a field: Lists of Materials)

The User can add his materials to a custom list and can add how big the match needs to be with the furniture for example:
(User list)

1. Stone

2. Marble

3.Wood

4. Steel

Match > 50%

On the basis of this list, I want to filter a Repeating Group: Do a search for furniture.
So when an item of furniture in the database has the materials:

1. Stone

2. Marble

3. Wood

4. Iron

It should match with 75% and show it in the Repeating group. (because it’s above the required 50%)
I have tried a lot of things but I can’t seem to figure out this problem. I have tried using intersect with but doesn’t seem to fix the problem. Do you know a possible solution? If you need more information to help me with this problem, don’t hesitate to ask in the comments.

Thank you for reading this post .

[cmarchan]

Seems like a job for advanced filtering.

When doing a search … in “more” look for the operator :filter … and then look for “advanced filter”. There you write expression like “list A materials contains list of list B materials”