Hi guys and gals, i am new to bubble and need some guidance. I am doing a listing search filters and hitting a wall.
I have a yes/no field(Important) in a table(Listing)
In the filtered list i have a dropdown (DropdownImportant) with the values Both, Important Only and Not Important.
I need the list to be unfiltered by this field when Both is selected and filtered to Yes or No options.
I was told (by ChatGTP ;)) to use :filtered and Advanced to build the filter conditions. The issue I am having is the lack of brackets for grouping conditions.
I am trying to achieve this:
DropdownImportant’s value is “Both”
or (DropdownImportant’s value is “Important Only” and This Listing’s Important is yes)
or (DropdownImportant’s value is “Not Important” and This Listing’s Important is no)
What happens is that i cannot figure out how to add brackets to the expression. I can only write it by selecting the next value and no brackets are available or added automatically.
What am i doing wrong?
Second, I don’t recommend using Advanced Filtering. Maybe try to adjust your database so you don’t have to do advanced filtering. It will be heavy on Workload.
I knew i was missing something! Thank you a lot! I have made it work with customstate, but wanted to see how to do this the “original” way.
I am all for performance :), so how would you approach the situation where I need to match ranges?
My Listing may have an exact price (34 dollars) or may have a range (25-50$).
User searching will enter range (36-55). I need to filter all listings where exact price will fall into the searched range OR any part of the listing’s range will fall into searched range.
Again ChatGTP suggested the following (again with brackets LOL). What is the best practice for something like this? :
(This Listing’s price_exact ≥ Input MinPrice’s value
and This Listing’s price_exact ≤ Input MaxPrice’s value)
or
(This Listing’s price_min ≥ Input MinPrice’s value
and This Listing’s price_min ≤ Input MaxPrice’s value)
or
(This Listing’s price_max ≥ Input MinPrice’s value
and This Listing’s price_max ≤ Input MaxPrice’s value)
or
(This Listing’s price_min ≤ Input MinPrice’s value
and This Listing’s price_max ≥ Input MaxPrice’s value)
Yes! That is it. Thank you VERY much. this is much simpler and cleaner then what i had.
For the other people who will be looking for an answer.
priceRange is a field on Product with the type of “numeric range”
