Returns a filtered, sorted collection.
row.paymentCustomer.ordersList, // input collection
"row.amount_un_paid > 0", // filter
"placed_date a") // sort
- The input collection (often a child accessor, as shown here for payments)
This construct queries the input collection from the database, and performs an in-memory filter/sort.
- It is an excellent choice if the input collection is small, or is re-used in the transaction (since it leverages the transaction cache)
- It is a poor choice if the input collection is very large. In such cases, use a SQL Select.