imagine the example of invoices and invoice rows. If I do the query in SQL, with joins I will get as many rows as there are invoice rows.
But with criteria it asks me who is the root of the query, in this case invoice, but it brings me all the rows without grouping them in lists in the invoice:
What criteria gives me:
Line 1 -> Invoice 1
Line 2 -> Invoice 1
Line 3 -> Invoice 2
What I want:
Invoice 1 -> Line 1, line 2
Invoice 2 -> Line 3
How would you do it?
I doubt that anyone could give you any suggestions unless you show the code.
I can't show it. But is a really basic query to make I think. I mean, or you know if it's possible or you don't know it
Обсуждают сегодня