With the new Join way, can I sort by specifiying a field?

[vicenrico]

 @Join(to = LineItem.class, onProperties = "id", toProperties = "invoiceId")
    private List<LineItem> lineItems = new ArrayList<>();

Is it possible to sort this lineItems ArrayList?. I mean: If i have a LineItem with itemName and ItemDescription, is there any way to specify the field by which I want to sort the list? for instance: itemName or itemDescription. I know I can do it after retrieving the list, but I use sqlite and this db has a rowId that I use as a primary key and is 'hidden'. Of course, this is the field I want to sort by.

[sproket]

Hi!

No the sub query doesn't have a way to add any order by to the child table. That might make the query slow. I think the rowid would be sorted though it if has an index. If you paste me an example I could try it out and see.