What is the best way to make use of the new “scoping” operators and
otherwise search the database using deep relationship chains
Take for example that I want to query what items all customers have ever
bought from one salesman
salesman has-many customers
customers have-many orders
orders have many items
Now I want to write an application which is for the use of only one
salesman who can see only details about their customers and their
orders. Can the new scoping operators help me out here? How would the
scoping be phrased in this case please?
eg in orders/list can we do better than some custom SQL? (limiting to
only orders by the logged in salesman) What about finding the unique
list (and perhaps count) of all items sold (by that salesman)?
Thanks for any pointers
Ed W