Good day
Consider a dataset model containing an Order and OrderLine table model, with the relation on the OrderNo field.
Thus, to retrieve and Order with its Lines, I can do this:
dsm = NEW OrderDatasetModel().
dsm:Order:Filter:OrderNo:EQ(15).
dsm:Order:FillOrderLine = TRUE.
dsm:Order:Fill().
However, in my use case, I only want some of those order lines, lets say only the ones with a Status less that 10.
What is the simplest correct way to achieve this?
I tried the following, but the filter on OrderLine is ignored and I still get all the OrderLine records:
dsm = NEW OrderDatasetModel().
dsm:Order:Filter:OrderNo:EQ(15).
dsm:Order:FillOrderLine = TRUE.
dsm:OrderLine:Filter:Status:LT(10).
dsm:Order:Fill().
Regards
Simon