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

Hello everyone - I think I’m going to go crazy soon :slight_smile: 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???

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

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

@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?

Hi, @paul29 thanks in advance!


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?

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.

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 - it seems to be right way for my solution, but I couldn’t filter by the list of values

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

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.

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.




The main problem is when i set filter: Facilities contains RG Facilities’s Selected - it needs more… how to end a condition?

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

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

Can you send a screenshot of your current filter settings?

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”?

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

ooooooooo yeah :slight_smile: 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!

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.

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.