Utilizing JayData, I am fetching a table along with other tables through a join operation.
The code I have written is as follows:
db.Table1.include("Table2").include("Table3").toArray();
However, my issue arises when I try to sort the data based on a field in Table3
. When I attempt to do this using the .order
method like below...
db.Table1.include("Table2").include("Table3").order("FieldName").toArray();
...the code breaks because it cannot find the specified fieldname in Table1. The order filter seems to default to Table1
, whereas I actually want to order by a field in Table3
. Is there a way to achieve this?