[Bubble Limit] Conditionnal filter within a search - why isn't is easier?

[nicolas_dap]

Let’s say I want to apply a 10% discount to Cart’s Orders, on Products from some Categories :

That is fine. Nevertheless, most of the time, discount apply on all the products, without any restriction on their categories.

1st method, writing a single query :
I must ensure that all existing Categories are copied in each Discount’s Categories. Risky workaround.

2nd method, writing 2 searches for 1 conditionnal criteria.
But with 2 conditionnal criterias, 4 searches are needed. With 3 conditionnal criterias, 9 searches, etc. Painful and risky too.

If a search filter could be ignored with a condition, it would make it much easier :

There may be a technical reason why this has not be implemented yet, no ?

[nicolas_dap]

here same pain it seems

1 Idea to improve Bubble: Add toggle for search filters so that when filter is null, either filter all values out or filter none out

It seems to me that one aspect of Bubble that is really confusing for Bubblers is the notion of “search for” filtering on a value that is null. And, it’s also counter-intuitive at times for regular Bubblers such as myself. When “:count” is added after it, then it counts as none. When the result is just a list, then that search filter won’t filter out any of the values so all values will be returned. This is not at all intuitive for non-engineers. I understand why this is often the desired b…

[sridharan.s]

This is on Bubble’s roadmap. See Ongoing > Features & Capabilities > 1st Item: Make the new default for searches be that null constraints AREN’T dropped

[nicolas_dap]

All right. Thks !