Issue with a Custom State to a Filter RG

VincentRedor · 2021-01-21T13:59:07.713Z

Good morning fellow Bubblers!

Context
I’m developing a brand directory allowing people to find ethical and sustainable brands. The index has one main repeating group and a bunch of filters (category, subcategories, targets, price range, ethical level, etc.)
Yesterday, I tackled the custom states implementation on the “Category Filter” and “Ethical Level” to let users multi-select them and get more granular results.

Issue
It worked as intended on the “Ethical Level” because a brand has only one level of ethic.
But because a brand may have multiple categories (list) assigned to it (which is the main difference), I can’t make the result appear on the RG.

Here is a screenshot showing the issue. It works only if I add :random at the end, but it messes the results…

Capture d’écran 2021-01-21 à 08.54.321412×1254 139 KB

I would be very glad to find help to fix this.
Thanks a lot in advance for your time!

Jici · 2021-01-21T14:01:16.292Z

I guess that your “Index’s Category” is a list and with Contains, Bubble expect unique value. It will work with random, first item, item #… If user can only select 1 category, change the state to be a single value, only a list. If you want to use a list of category, you may consider intersect or advanced filtering

VincentRedor · 2021-01-21T14:04:12.634Z

Correct.
Can you tell me more about advanced filtering in the case of letting people interact with multiple categories?

Jici · 2021-01-21T14:13:05.413Z

When you Get data (using Do a search for example), directly in the Do a search, you cannot compare a list with another. It’s actually a limitation on Bubble side. The only way to do it is to, after the “Search for Brands” click “more” and select :filtered. In Filtering, you have a function Called “Advanced”. This is where you can enter more complex request and, in your case, you will be able to compare two list.

It will probably look like This Brands’s category intersect with Category State list: count > 0

VincentRedor · 2021-01-21T14:51:31.935Z

I feel dumb, but I cannot see the “Advanced” setting when :filtered is applied after “Search for Brands”.

Capture d’écran 2021-01-21 à 09.50.041640×548 56.2 KB

Jici · 2021-01-21T14:51:56.891Z

Click + Add a new constraint

VincentRedor · 2021-01-21T14:57:20.777Z

Capture d’écran 2021-01-21 à 09.55.30

It’s done. Now the results are “empty”.

Capture d’écran 2021-01-21 à 09.56.352034×952 27.1 KB

Jici · 2021-01-21T15:00:14.882Z

Check in debug mode to see what is returned on each step.
Also, you may need to have a condition that will manipulate the list according to state. If state is empty or not. (Empty, you should remove the filtered)

VincentRedor · 2021-01-21T15:08:59.216Z

I see. First, here is the log on the debug mode, maybe you’ll notice something in it.

Capture d’écran 2021-01-21 à 10.07.402862×1100 231 KB

Jici · 2021-01-21T15:10:17.391Z

Click on “Search for Brand:filtered”
At the right, you will be able to click on each section of the expression and this will show you the results or each part and the final result too

VincentRedor · 2021-01-21T15:15:14.441Z

I’m learning things everyday, I love it! Thanks for the “debug mode tip”.
Here are the screenshots of both parts of the expression. I don’t really know what I should be looking for.

Capture d’écran 2021-01-21 à 10.12.40836×474 45.7 KB

Capture d’écran 2021-01-21 à 10.12.52840×480 32.8 KB

Jici · 2021-01-21T15:58:24.088Z

Did you click on “empty” in advanced?

VincentRedor · 2021-01-21T17:47:58.010Z

Sorry for the delay Jici, I’m now back in front of the computer.
So I figured out that it displays properly the results only when at least one of the category filters is pressed, even if “Ignore empty constraints” is checked in both “brand contraints” and “:filtered constraints”.

So, I put a conditional directly on the “brand’s repeating group” saying that if the custom state is < 1 then change data source to “Search for Brands”. And now it works smoothly.

Thanks a lot for your help, it was really appreciated.
Hoping this thread is going to be helpful for other people as well!

system · 2021-04-01T13:59:11.937Z

This topic was automatically closed after 70 days. New replies are no longer allowed.