Hi, I had a challenge that is similar to yours in that I am trying to filter a list of entries with a list of subjects in an option set. I suppose if your dataset isn’t huge, you could generate repeating group lists on your page, and then search based on those and/or use the intersect with function.
I ended up using advanced filters, with help from this post: Searching using multi dropdown - possible/alternative? Incompatible type
Note when using advanced filters and “intersect with”, the “:count” function is essential since that’s how you determine how the two lists should line up. Regarding your goal to only return results that contain all of the user’s equipment, in the advanced filter I’d try something along the lines of searching for Workouts and using an advanced filter like… “Advanced: This User’s Equipment intersect with Workouts’s Equipment:Count >0 and This User’s Equipment:count [greater than or equal to] Workouts’s Equipment:count” I may not have written this 100% correctly but that’s the overall idea.
A warning though, advanced filters are not fast if your dataset is large. I was back and forth with Bubble support to confirm that there wasn’t some way to do this search on the server side, and they said no.