I have a database of Orders.
Those Orders have Customers.
Customer has Brands which are a list of Options.
Brands (option) have Attribute.
Attribute can be X or null.
How to properly setup (with as little frontend as possible) a Search for Orders which Customer Brands have X Attribute.
When I am setting this up I have:
Do a search for Orders:
Customer is in Do a search for Customer:
Brand contains … Get Option Brand. (*)
Get Option Brand Filtered Brand Attribute is X
(*) The problem here is that bubble expects that contains operator receives a single item, not a list. So how to find a workaround. As I currently can sum up those Customers on the Frontend, but I am trying to remove as much frontend calculations as I can.
I know that for the future I can try to save Brand on an Order, but for now I don’t have it.