Forum Academy Marketplace Showcase Pricing Features

Search for - value (of field of type list) in list

I have a table seekers wherein there is the field skills which is a list of text.

I struggle figuring out how to set up the constraint “at least one skills is in skills input’s value” as a seeker can have multiple skills and I want to be able to retrieve any one that has at least one skills included in the skills I want to have.

You could try the ‘intersect’ function.
So to check if at least one item from list A is in list B, you can do:
list A's items :intersect with list B's items :count > 0

In your case,
skills :intersect with skills input's value :count > 0

Cheers,
Ranjit | Blur Apps

1 Like

thanks; but I do not see where I should do this as the only options I have in the constraint block are "contains, does not contain, is empty, is not empty ".
I have the impression there is no built-in feature available to do it simply with bubble, the only way is to run a custom js script looping through each seeker, doing the check “skills :intersect with skills input’s value :count > 0”.
And if I was to do that, I would prefer doing it server side, but using toolbox for server scripts, I am facing another issue which I have written here: Advanced search for- included models

In the advanced filter feature I can actually perform this. The issue remains that I would prefer running these types of queries server side rather than client-side

Maybe rethink your DB design to fit the constraints of how you can query data in Bubble? :thinking:

i’ve tried to use several skill fields like skill_1, skill_2 instead of a list of skills. I intended to do a skill_1 is in input_list OR skill_2 in is in input_list; but this will be also be done front-side. so right now i still haven’t found the way to make it