Filtering a RG based on a field from another dependent field

[edurandrade]

Hello everyone, I’m stuck!
Until now I was able to find solutions through this great bubble.io forum, but right now I’m stuck!

I’ll explain: I’m managing a take-away restaurant where I receive tons of orders by phone! I have done an entire system to register the orders.

I also have three different kitchens/producers, or as I call, “Owners” to answer to these orders depending on the specific product or products that are being ordered.
Ex.: One Client may order for next sunday three different products - one product that has to be done by the “Kitchen”, one product by the “Bakery” and one product that has to be done/stored by the people that works on the “Store”

Each “Order” has a field called “Cart” composed by a List of “ProductsCart”.
Each “ProductCart” has some variables, and one of them is who is the “Owner”

The “Order” creation are going well, however, when I was doind the productions dashboards for the different “Owner”'s, I got stuck!

I want to make a Dashboard where I can filter the “Orders” (data type) depending on its “Due Date”(field) and at the same time depending on the counting (>0) of each “ProductCart” (data type) field “Owner” (field from data type “ProductCart”) value.

To conclude, the page of the “Kitchen 1” production will have a RG representing the list of “Orders” that have at least one “ProductCart” which the owner is “Kitchen1”

How do I create a RG with these constraints?

Orders:

ProductsCart:

Hope someone can help me,
Thank you

[bonjour_17]

I see multiple ways of doing so, here are 2:

1. using advanced filtering.
   Make your RG datasource a do search for Orders, filtered by date. And then :filtered Advanced like so :
   
   

note: even thought it says “each items contains” … it will work even when not all items contains the owner’s name.

cons: all orders that match the date filter will be loaded in front, even those who do not match the owner advanced filter. So might result in higher WU consumption.

2. Using grouping
   Search for productcards that match your criterias, and then group by order.

Cons: you might need to modify your dataset in order to copy the order timestamp on each productcart

[edurandrade]

Hello @bonjour_17 , thank you so much! I have no idea why I wasn’t able to do it.
I could promise that I had tried everything, your first solution included!

Now it’s working!

Thank you so much!