Do a search for using a list from a multiselect dropdown as constraints

[PersiKe]

Dear community,

I’m currently learning Bubble and have encountered a challenge I’m struggling to resolve.

Here’s my database structure:

Terms: This data type has 3 fields - name (text) ,weight (number), and color (number)
Ticket: This data type contains a bunch of fields, including a list of terms (the type mentioned above).

I have a multi-select dropdown populated with terms from the database, which I intend to use for dynamic filtering. My goal is to display a list of tickets in a repeating group that contains (at least) the terms selected in the multi-select dropdown.

Here’s an example to illustrate:

Terms: blue, red, green, purple, black, and white.
Tickets: Some tickets are associated with multiple terms.

My goal is to select a few terms (like blue, green, and black) in the multi-select dropdown and display all tickets that the terms list contains (at least) the ones selected.

I attempted to search for tickets and set a constraint such that terms contain multi-select dropdown values. However, it seems that the constraint on the search function only works with single items rather than a list of items.

Could anyone provide guidance on how to achieve this functionality? Any help or insights would be greatly appreciated!

Thank you!

[PersiKe]

After a lot of research on the forum, I found a solution. If you encounter the same issue, check out the message from [fayewatson] in March 2017 in this post: Can't get search to work.

You guys can close the topic

[msgiblin]

Hi there! You can mark your last post as the ‘solution’ which would mark this thread as complete, but also indicate to anyone staying for a similar solution that this thread has the answer(s) - although users will still be able to comment.

Glad you found your way! I read through the thread you linked to and both solutions given are solutions I currently employ and would recommend.