# Is it possible to filter by properties if there are more than one properties

**URL:** <https://forum.bubble.io/t/is-it-possible-to-filter-by-properties-if-there-are-more-than-one-properties/207736>\
**Category:** Database\
**Created:** [May 21, 2022, 11:11pm UTC](https://forum.bubble.io/t/is-it-possible-to-filter-by-properties-if-there-are-more-than-one-properties/207736 "2022-05-21T23:11:15Z")\
**Posts on this page:** 19\
**Page:** 1

<div class="post-metadata">

**Author:** ![yaroslav.naumov.only](https://avatars.discourse-cdn.com/v4/letter/y/96bed5/32.png) [@yaroslav.naumov.only](https://forum.bubble.io/u/yaroslav.naumov.only)\
**Post date:** [May 21, 2022, 11:11pm UTC](https://forum.bubble.io/t/is-it-possible-to-filter-by-properties-if-there-are-more-than-one-properties/207736/1 "2022-05-21T23:11:15Z")

</div>

Hello everyone - I think I’m going to go crazy soon 🙂 what a day I can’t figure out how to set up a filter in a repeating group with the help of checkboxes for several properties - that is, filter by a group of properties at once. Is it possible to do this? Setting up a filter for one property that has an entity does not cause problems - but how to make a filter for a group of certain properties selected in checkboxes for a group of objects???

---

<div class="post-metadata">

**Author:** ![paul29](https://avatars.discourse-cdn.com/v4/letter/p/5f8ce5/32.png) [@paul29](https://forum.bubble.io/u/paul29)\
**Post date:** [May 22, 2022, 12:52am UTC](https://forum.bubble.io/t/is-it-possible-to-filter-by-properties-if-there-are-more-than-one-properties/207736/2 "2022-05-22T00:52:30Z")

</div>

This is very difficult to follow. Please include screenshots as examples

---

<div class="post-metadata">

**Author:** ![cmarchan](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/cmarchan/32/253062_2.png) [@cmarchan](https://forum.bubble.io/u/cmarchan)\
**Post date:** [May 22, 2022, 2:06am UTC](https://forum.bubble.io/t/is-it-possible-to-filter-by-properties-if-there-are-more-than-one-properties/207736/3 "2022-05-22T02:06:19Z")

</div>

Hello @yaroslav.naumov.only welcome to the community!

[![](https://img.youtube.com/vi/jDqUSX2gx8o/maxresdefault.jpg "UPDATED: How to Use Filtering Techniques in Your Bubble.io No Code Web Apps") ](https://www.youtube.com/watch?v=jDqUSX2gx8o)

---

<div class="post-metadata">

**Author:** ![yaroslav.naumov.only](https://avatars.discourse-cdn.com/v4/letter/y/96bed5/32.png) [@yaroslav.naumov.only](https://forum.bubble.io/u/yaroslav.naumov.only)\
**Post date:** [May 22, 2022, 7:44pm UTC](https://forum.bubble.io/t/is-it-possible-to-filter-by-properties-if-there-are-more-than-one-properties/207736/4 "2022-05-22T19:44:13Z")

</div>

@cmarchan Hi, nice to meet you! I’ve already seen this tutorial - it’s a bit different what i need. I mean i created an entity in Database - called Facilities. There is a list of features that i use for Checkboxes RG on page. Also I created Option Sets that I use for features of my objects(it’s easy to arrange a new object with a lot of features). I set some features as list in one cell. Can i set up a filter for find an objects with some checked features from Checkboxes RG (each option is individual) on page from Database where Objects have column called Facilities and each cell has a list of features?

---

<div class="post-metadata">

**Author:** ![yaroslav.naumov.only](https://avatars.discourse-cdn.com/v4/letter/y/96bed5/32.png) [@yaroslav.naumov.only](https://forum.bubble.io/u/yaroslav.naumov.only)\
**Post date:** [May 22, 2022, 8:02pm UTC](https://forum.bubble.io/t/is-it-possible-to-filter-by-properties-if-there-are-more-than-one-properties/207736/5 "2022-05-22T20:02:13Z")

</div>

Hi, @paul29 thanks in advance!

 ![Example](https://us1.discourse-cdn.com/bubble/original/3X/b/b/bb5e246aa1677c101ffd429e3b34577bbf91f65c.jpeg)  
Here’s example what i need. To create a filter Checkboxes RG with different independent options, but objects in DB have only one cell there is a list of these options. Can i do these in bubble?

---

<div class="post-metadata">

**Author:** ![paul29](https://avatars.discourse-cdn.com/v4/letter/p/5f8ce5/32.png) [@paul29](https://forum.bubble.io/u/paul29)\
**Post date:** [May 22, 2022, 9:54pm UTC](https://forum.bubble.io/t/is-it-possible-to-filter-by-properties-if-there-are-more-than-one-properties/207736/6 "2022-05-22T21:54:53Z")

</div>

So if I understand your question correctly, if you tick the tickbox in cell B4 (corresponding to “1”) then your repeating group should show “a” and “d”? Is that right? If not, please lay out an example like that.

---

<div class="post-metadata">

**Author:** ![yaroslav.naumov.only](https://avatars.discourse-cdn.com/v4/letter/y/96bed5/32.png) [@yaroslav.naumov.only](https://forum.bubble.io/u/yaroslav.naumov.only)\
**Post date:** [May 22, 2022, 10:16pm UTC](https://forum.bubble.io/t/is-it-possible-to-filter-by-properties-if-there-are-more-than-one-properties/207736/7 "2022-05-22T22:16:54Z")

</div>

Right. Also it needs to combine conditions - for example, if i tick the tickboxes in B6, B8 and B13 then RG should show only ‘b’. I’ve seen this - [Bubble.io Tutorial: How to Select Multiple Items From a List - YouTube](https://www.youtube.com/watch?v=yahP3RyVggY&t=96s) - it seems to be right way for my solution, but I couldn’t filter by the list of values

---

<div class="post-metadata">

**Author:** ![paul29](https://avatars.discourse-cdn.com/v4/letter/p/5f8ce5/32.png) [@paul29](https://forum.bubble.io/u/paul29)\
**Post date:** [May 22, 2022, 10:20pm UTC](https://forum.bubble.io/t/is-it-possible-to-filter-by-properties-if-there-are-more-than-one-properties/207736/8 "2022-05-22T22:20:33Z")

</div>

Can you please send a screenshot of your DB app data where these facilities are stored?

---

<div class="post-metadata">

**Author:** ![yaroslav.naumov.only](https://avatars.discourse-cdn.com/v4/letter/y/96bed5/32.png) [@yaroslav.naumov.only](https://forum.bubble.io/u/yaroslav.naumov.only)\
**Post date:** [May 22, 2022, 10:29pm UTC](https://forum.bubble.io/t/is-it-possible-to-filter-by-properties-if-there-are-more-than-one-properties/207736/9 "2022-05-22T22:29:20Z")

</div>

I have type Facilities for arranging RG on page, Option sets with list of Facilities for easy way to arrange every object, and Field Facilities in each object to contain all set facilities in one cell.

---

<div class="post-metadata">

**Author:** ![paul29](https://avatars.discourse-cdn.com/v4/letter/p/5f8ce5/32.png) [@paul29](https://forum.bubble.io/u/paul29)\
**Post date:** [May 22, 2022, 10:31pm UTC](https://forum.bubble.io/t/is-it-possible-to-filter-by-properties-if-there-are-more-than-one-properties/207736/10 "2022-05-22T22:31:29Z")

</div>

It’s much more work for me to try and visualize everything. Can you please send a screenshot of your app data and your data types. You can redact the data if you need.

---

<div class="post-metadata">

**Author:** ![yaroslav.naumov.only](https://avatars.discourse-cdn.com/v4/letter/y/96bed5/32.png) [@yaroslav.naumov.only](https://forum.bubble.io/u/yaroslav.naumov.only)\
**Post date:** [May 22, 2022, 10:43pm UTC](https://forum.bubble.io/t/is-it-possible-to-filter-by-properties-if-there-are-more-than-one-properties/207736/11 "2022-05-22T22:43:58Z")

</div>

![Example](https://us1.discourse-cdn.com/bubble/original/3X/6/3/637d94303c74151df091c5249a497a286fd8f97c.jpeg)  
 ![Example2](https://us1.discourse-cdn.com/bubble/original/3X/0/8/08915ee8fc9a63396bd797d543f00fc61b8911e4.jpeg)  
 ![Example3](https://us1.discourse-cdn.com/bubble/original/3X/6/8/68b7ab85d0e2456a7a88f2877e67c5ae55be2872.jpeg)  
The main problem is when i set filter: Facilities contains RG Facilities’s Selected - it needs more… how to end a condition?

---

<div class="post-metadata">

**Author:** ![paul29](https://avatars.discourse-cdn.com/v4/letter/p/5f8ce5/32.png) [@paul29](https://forum.bubble.io/u/paul29)\
**Post date:** [May 22, 2022, 10:46pm UTC](https://forum.bubble.io/t/is-it-possible-to-filter-by-properties-if-there-are-more-than-one-properties/207736/12 "2022-05-22T22:46:16Z")

</div>

When you are clicking the multiple tickboxes, are you storing those tickboxes selected into a state which is a list of values?

---

<div class="post-metadata">

**Author:** ![yaroslav.naumov.only](https://avatars.discourse-cdn.com/v4/letter/y/96bed5/32.png) [@yaroslav.naumov.only](https://forum.bubble.io/u/yaroslav.naumov.only)\
**Post date:** [May 22, 2022, 10:51pm UTC](https://forum.bubble.io/t/is-it-possible-to-filter-by-properties-if-there-are-more-than-one-properties/207736/13 "2022-05-22T22:51:36Z")

</div>

Of course. Almost the same filter works, but it filters the cells of objects with a single value. Here i need to filter the cells of objects with multiple values

---

<div class="post-metadata">

**Author:** ![paul29](https://avatars.discourse-cdn.com/v4/letter/p/5f8ce5/32.png) [@paul29](https://forum.bubble.io/u/paul29)\
**Post date:** [May 22, 2022, 10:53pm UTC](https://forum.bubble.io/t/is-it-possible-to-filter-by-properties-if-there-are-more-than-one-properties/207736/14 "2022-05-22T22:53:32Z")

</div>

Can you send a screenshot of your current filter settings?

---

<div class="post-metadata">

**Author:** ![paul29](https://avatars.discourse-cdn.com/v4/letter/p/5f8ce5/32.png) [@paul29](https://forum.bubble.io/u/paul29)\
**Post date:** [May 22, 2022, 11:00pm UTC](https://forum.bubble.io/t/is-it-possible-to-filter-by-properties-if-there-are-more-than-one-properties/207736/16 "2022-05-22T23:00:58Z")

</div>

Your repeating group has a state called selected, which based on the red text, is not the same type as facilities. What state type is “selected”?

---

<div class="post-metadata">

**Author:** ![paul29](https://avatars.discourse-cdn.com/v4/letter/p/5f8ce5/32.png) [@paul29](https://forum.bubble.io/u/paul29)\
**Post date:** [May 22, 2022, 11:31pm UTC](https://forum.bubble.io/t/is-it-possible-to-filter-by-properties-if-there-are-more-than-one-properties/207736/18 "2022-05-22T23:31:47Z")

</div>

Try changing your “Facilities contains…” to “Facilities contains list…” in your list filter

---

<div class="post-metadata">

**Author:** ![yaroslav.naumov.only](https://avatars.discourse-cdn.com/v4/letter/y/96bed5/32.png) [@yaroslav.naumov.only](https://forum.bubble.io/u/yaroslav.naumov.only)\
**Post date:** [May 23, 2022, 12:14am UTC](https://forum.bubble.io/t/is-it-possible-to-filter-by-properties-if-there-are-more-than-one-properties/207736/19 "2022-05-23T00:14:15Z")

</div>

ooooooooo yeah 🙂 that’s much better. Deeply appreciate your help! I ll be happy to treat you a beer or smth like that if we ever met. Anyway If use Option Sets for creating new objects filter is still not working. Nevertheless, I am glad with what happened now. Thanks!

---

<div class="post-metadata">

**Author:** ![paul29](https://avatars.discourse-cdn.com/v4/letter/p/5f8ce5/32.png) [@paul29](https://forum.bubble.io/u/paul29)\
**Post date:** [May 23, 2022, 12:15am UTC](https://forum.bubble.io/t/is-it-possible-to-filter-by-properties-if-there-are-more-than-one-properties/207736/20 "2022-05-23T00:15:59Z")

</div>

np. Happy to help.

Your issue is a little hard to debug over the forum. It’s definitely doable but you just need to keep playing around.

---

<div class="post-metadata">

**Author:** ![ed727](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/ed727/32/71942_2.png) [@ed727](https://forum.bubble.io/u/ed727)\
**Post date:** [May 23, 2022, 12:59am UTC](https://forum.bubble.io/t/is-it-possible-to-filter-by-properties-if-there-are-more-than-one-properties/207736/21 "2022-05-23T00:59:43Z")

</div>

Hi, also make sure you’ve checked out the “intersect with” constraint that’s available under an advanced filter. It allows you to search a list based on a list. (Search the forum and you’ll see it explained).

Problem is that as an advanced filter it’s client side, so it’s not scalable with large data sets. The workaround for that may be a joining table.
