[QueryBuilder] How can you filter a multi relationship?
Is it possible to filter multiple relationships with the new query builder?
We would like to filter something like this: users->orders(), and from orders we would like to filter on the products within the orders (if that makes sense). Products looks something like this: products()->categories. So ideal, we would like to filter the product categories as well.
It will probably work fine when adding this directly onto the OrderResource or ProductResource, but our team would like to use users a starting point, so they can connect multiple relationships (non-related to orders) at once.
Or should you use the Filters for this?
Thanks!
We would like to filter something like this: users->orders(), and from orders we would like to filter on the products within the orders (if that makes sense). Products looks something like this: products()->categories. So ideal, we would like to filter the product categories as well.
It will probably work fine when adding this directly onto the OrderResource or ProductResource, but our team would like to use users a starting point, so they can connect multiple relationships (non-related to orders) at once.
Or should you use the Filters for this?
Thanks!
