# Displaying records containing multidropdown selected options **URL:** \ **Category:** Database\ **Created:** [May 16, 2020, 9:27am UTC](https://forum.bubble.io/t/displaying-records-containing-multidropdown-selected-options/92080 "2020-05-16T09:27:43Z")\ **Posts on this page:** 17\ **Page:** 1
**Author:** ![jamesleese5](https://avatars.discourse-cdn.com/v4/letter/j/5fc32e/32.png) [@jamesleese5](https://forum.bubble.io/u/jamesleese5)\ **Post date:** [May 16, 2020, 9:27am UTC](https://forum.bubble.io/t/displaying-records-containing-multidropdown-selected-options/92080/1 "2020-05-16T09:27:43Z")
When the value of my multidropdown list changes I want to do a search displaying records containing ANY item in the multidropdown list’s value. I can only see how to display records containing a specific :item #. New to bubble so any tips appreciated! ---
**Author:** ![mikeloc](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/mikeloc/32/93001_2.png) [@mikeloc](https://forum.bubble.io/u/mikeloc)\ **Post date:** [May 16, 2020, 9:41am UTC](https://forum.bubble.io/t/displaying-records-containing-multidropdown-selected-options/92080/2 "2020-05-16T09:41:42Z")
Hi there, @jamesleese5… I’m sure there is more than one way to do what you are trying to do, but I have done it with an advanced filter combined with the `intersect with` option like this… ![multi1](https://us1.discourse-cdn.com/bubble/original/3X/5/e/5ec59a93493b952da914e0ef73aab7ad089af9bc.png) Want to give that a try and see if you get the desired result? Best… Mike ---
**Author:** ![jamesleese5](https://avatars.discourse-cdn.com/v4/letter/j/5fc32e/32.png) [@jamesleese5](https://forum.bubble.io/u/jamesleese5)\ **Post date:** [May 16, 2020, 12:22pm UTC](https://forum.bubble.io/t/displaying-records-containing-multidropdown-selected-options/92080/3 "2020-05-16T12:22:58Z")
Thanks for the help @mikeloc. That is now working well! ---
**Author:** ![jnm528](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/jnm528/32/61244_2.png) [@jnm528](https://forum.bubble.io/u/jnm528)\ **Post date:** [May 18, 2020, 5:37am UTC](https://forum.bubble.io/t/displaying-records-containing-multidropdown-selected-options/92080/4 "2020-05-18T05:37:49Z")
Hey @mikeloc! I’ve read literally every single thread I can find related to filtering multidropdowns and am hoping you can help? I’m relatively new to Bubble and have been banging my head against the wall for 2 days on this one. So I’ve got two filtering Criteria: Brand Types and Collab Types. Both are lists (can be multiple items). Example: Bacardi’s Brand Type: Alcohol Collab Type: Paid, Free Product (List of 2 items) Pantene’s Brand Type: Hair, Personal care (List of 2 items) Collab Type: Free Product I can get each individual dropdown filtering properly using your approach: ![Screen Shot 2020-05-17 at 10.34.30 PM](https://us1.discourse-cdn.com/bubble/original/3X/1/7/176e1bb5174f9f4ba09eaf974695b4fda901f831.png) But when I want the filters to work _together_, I thought this approach would work: ![Screen Shot 2020-05-17 at 10.28.59 PM](https://us1.discourse-cdn.com/bubble/original/3X/e/6/e6bc4b2d3b64120b0cd9aebdd895913a3e9a3acd.png) But no dice. Here’s what my app looks like: ![Screen Shot 2020-05-17 at 10.27.47 PM](https://us1.discourse-cdn.com/bubble/original/3X/1/3/136ba35e4b3eacec6d118b13640ca1124c18e67b.png) When I clicked “Paid”, I would expect the only result to be Bacardi now since it’s the only Brand that has Paid as a Collab Type. Hopefully this makes sense and thanks so much in advance for any guidance you can provide =) Justin ---
**Author:** ![mikeloc](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/mikeloc/32/93001_2.png) [@mikeloc](https://forum.bubble.io/u/mikeloc)\ **Post date:** [May 18, 2020, 11:02am UTC](https://forum.bubble.io/t/displaying-records-containing-multidropdown-selected-options/92080/5 "2020-05-18T11:02:57Z")
Hi there, @jnm528… I did a quick test using a similar example, and I _think_ you just need to combine those two filters. So, at the end of the first advanced filter, select the `and` option, and then build out the same query you have in your second advanced filter (and then make sure to delete the second advanced filter, of course). Want to give that a shot and see if it works for you? Best… Mike ---
**Author:** ![jnm528](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/jnm528/32/61244_2.png) [@jnm528](https://forum.bubble.io/u/jnm528)\ **Post date:** [May 18, 2020, 2:42pm UTC](https://forum.bubble.io/t/displaying-records-containing-multidropdown-selected-options/92080/6 "2020-05-18T14:42:11Z")
Hmm that was a great idea @mikeloc !! But…unfortunately that seems to turn off filtering altogether. This is what you were talking about right? ![Screen Shot 2020-05-18 at 7.40.23 AM](https://us1.discourse-cdn.com/bubble/original/3X/5/9/59dc31d4ac3b28d164bcb53fa404286f12409202.png) ---
**Author:** ![mikeloc](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/mikeloc/32/93001_2.png) [@mikeloc](https://forum.bubble.io/u/mikeloc)\ **Post date:** [May 18, 2020, 5:45pm UTC](https://forum.bubble.io/t/displaying-records-containing-multidropdown-selected-options/92080/7 "2020-05-18T17:45:20Z")
Yup, that’s what I was talking about, @jnm528. I just recreated your example, and it’s working like a charm for me… ![brands1](https://us1.discourse-cdn.com/bubble/original/3X/d/5/d5286d629ab8832552d49f6456482ef857b0a55c.png) … and both of these configurations produce the desired results… ![brands2](https://us1.discourse-cdn.com/bubble/original/3X/7/1/71760ec4a7de58fbff1539d4771bfeee67addf27.png) ![brands3](https://us1.discourse-cdn.com/bubble/original/3X/5/8/580a70a6f62073a4c4c547e24ca58da6bf312e05.png) It looks like you are using a custom state in your example, and I am just filtering a repeating group, so maybe that has something to do with why it’s not working for you (custom states are not my strong suit). But it’s definitely working for me, so without knowing exactly how you have things configured. I’m not sure what’s going on. Best… Mike ---
**Author:** ![jnm528](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/jnm528/32/61244_2.png) [@jnm528](https://forum.bubble.io/u/jnm528)\ **Post date:** [May 18, 2020, 8:53pm UTC](https://forum.bubble.io/t/displaying-records-containing-multidropdown-selected-options/92080/8 "2020-05-18T20:53:18Z")
I’m so, so appreciative of your help @mikeloc! As you suggested I scrapped the Custom state config and implemented in the RG Appearance and it works, woohoo! A slight wrinkle though, which is that it’s not working quite the way I expect when either multi-dropdown is empty. For example, the behavior I want if the Collab type dropdown is empty, I will show all results that include the Brand type filter. So the user entering “Alcohol and Hair” would see Pantene and Bacardi. Similarly, if they entered “Paid” in the Collab type and “Brand Type” is empty, they’d only see Bacardi. I’m essentially merging 3 different filtered searches together and trying to display unique elements. What am I missing here? ![Screen Shot 2020-05-18 at 1.47.38 PM](https://us1.discourse-cdn.com/bubble/original/3X/2/4/24c0cdfd6630d946d25946378fbdf21cec6815a8.png) ![Screen Shot 2020-05-18 at 1.47.31 PM](https://us1.discourse-cdn.com/bubble/original/3X/9/6/96c65be93081c22afccd1766e48a13adb24e248f.png) ![Screen Shot 2020-05-18 at 1.47.26 PM](https://us1.discourse-cdn.com/bubble/original/3X/3/5/3522f6765f4257ae87eaabe30b6894153481807c.png) Thank you so much!!! ---
**Author:** ![mikeloc](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/mikeloc/32/93001_2.png) [@mikeloc](https://forum.bubble.io/u/mikeloc)\ **Post date:** [May 19, 2020, 2:59pm UTC](https://forum.bubble.io/t/displaying-records-containing-multidropdown-selected-options/92080/9 "2020-05-19T14:59:27Z")
Hey there, @jnm528… after _a lot_ of messing around with this one, this filter appears to produce the desired results… ![multi](https://us1.discourse-cdn.com/bubble/original/3X/4/f/4f8283c0217b7eee70b08c9c25f02b852559a79a.png) Want to give it a shot? Best… Mike ---
**Author:** ![jnm528](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/jnm528/32/61244_2.png) [@jnm528](https://forum.bubble.io/u/jnm528)\ **Post date:** [May 19, 2020, 4:32pm UTC](https://forum.bubble.io/t/displaying-records-containing-multidropdown-selected-options/92080/10 "2020-05-19T16:32:07Z")
Holy cow, @mikeloc! I don’t think you quite know how much I appreciate your help on this one – I was going CRAZY! That did the trick. As a small token of my gratitude, I just made a donation to the American Diabetes Association – I saw the site in your profile and figured there may be a personal connection. ![Screen Shot 2020-05-19 at 9.25.41 AM](https://us1.discourse-cdn.com/bubble/original/3X/1/3/13df6f4cda7174f97ceb66499d34a861088fb934.png) Thank you so much again! Justin ---
**Author:** ![mikeloc](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/mikeloc/32/93001_2.png) [@mikeloc](https://forum.bubble.io/u/mikeloc)\ **Post date:** [May 19, 2020, 4:55pm UTC](https://forum.bubble.io/t/displaying-records-containing-multidropdown-selected-options/92080/11 "2020-05-19T16:55:20Z")
Now it’s my turn… holy cow, @jnm528! It was my pleasure to help, and I can’t thank you enough for showing your appreciation the way you did. You rock, man. Thanks again! Best… Mike ---
**Author:** ![jnm528](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/jnm528/32/61244_2.png) [@jnm528](https://forum.bubble.io/u/jnm528)\ **Post date:** [May 19, 2020, 5:06pm UTC](https://forum.bubble.io/t/displaying-records-containing-multidropdown-selected-options/92080/12 "2020-05-19T17:06:44Z")
Absolutely, @mikeloc, you’re welcome – thank you so much again! ---
**Author:** ![SerPounce](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/serpounce/32/62068_2.png) [@SerPounce](https://forum.bubble.io/u/SerPounce)\ **Post date:** [May 19, 2020, 5:15pm UTC](https://forum.bubble.io/t/displaying-records-containing-multidropdown-selected-options/92080/13 "2020-05-19T17:15:28Z")
There is a lot of great partnership and support that gets done through this forum. But this thread absolutely represents the best of it. Great stuff y’all!!! ---
**Author:** ![luiz.bittencourt](https://avatars.discourse-cdn.com/v4/letter/l/dfb087/32.png) [@luiz.bittencourt](https://forum.bubble.io/u/luiz.bittencourt)\ **Post date:** [December 17, 2020, 2:08pm UTC](https://forum.bubble.io/t/displaying-records-containing-multidropdown-selected-options/92080/14 "2020-12-17T14:08:59Z")
Hey @mikeloc, I’m trying to reproduce the same filter you explained to @jnm528 but struggling to make it work. This is my setup: ![image](https://us1.discourse-cdn.com/bubble/original/3X/d/8/d8092450e8631e434e284d26b8dec97f5499f9be.png) I’d like to filter Users according to some ‘tag’ associate with them (almost the same thing as @jnm528 did but in a simpler way – just one multi-dropdown element) Can you give me a hint about what’s wrong with my configuration? Thank you! Luiz ---
**Author:** ![mikeloc](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/mikeloc/32/93001_2.png) [@mikeloc](https://forum.bubble.io/u/mikeloc)\ **Post date:** [December 17, 2020, 2:14pm UTC](https://forum.bubble.io/t/displaying-records-containing-multidropdown-selected-options/92080/15 "2020-12-17T14:14:11Z")
Hi there, @luiz.bittencourt… if I understand your question correctly, I believe you only need the part after the “or” in your advanced filter. Want to give that a shot and see if it produces the desired result? Best… Mike ---
**Author:** ![luiz.bittencourt](https://avatars.discourse-cdn.com/v4/letter/l/dfb087/32.png) [@luiz.bittencourt](https://forum.bubble.io/u/luiz.bittencourt)\ **Post date:** [December 17, 2020, 2:30pm UTC](https://forum.bubble.io/t/displaying-records-containing-multidropdown-selected-options/92080/16 "2020-12-17T14:30:23Z")
THANKS, @mikeloc !!! Worked like a charm! In fact, the first filter worked too. The reason was a silly problem with the visualization element only!.. Beginner’s mistake! 🤦‍♂️ But now, it’s working! Tks again! Luiz ---
**Author:** ![hkhalil1803](https://avatars.discourse-cdn.com/v4/letter/h/13edae/32.png) [@hkhalil1803](https://forum.bubble.io/u/hkhalil1803)\ **Post date:** [March 9, 2021, 2:02pm UTC](https://forum.bubble.io/t/displaying-records-containing-multidropdown-selected-options/92080/17 "2021-03-09T14:02:22Z")
Hi @mikeloc , I am trying to execute something similar to the advanced filter expression you have helped everyone with above, however, without a dropdown input… I have been trying for hours and cannot figure it out! I am hoping you could possibly help me out. I have “orders” which contains a list of dates and a selection of products, these orders also have their parent profiles linked to them with an entry labelled “business”. I want to intersect my current pages order dates and products with the rest of the databases orders, and pull a result of a list of orders who’s dates and products intersect inside of “Verify 1” RG. I cant get the first filter to work let alone the second! ![Screen Shot 2021-03-10 at 12.54.29 am](https://us1.discourse-cdn.com/bubble/original/3X/a/5/a5b5e45ce6c34b3f96124b6077df2a39ecef79b5.png) This expression ends up just giving me a full list of all the Businesses Orders… I’m not sure what I am doing wrong ☹