ObjectDB ObjectDB

Group by: list if no aggregate function is specified

#1

Hello!

In a query like SELECT parent, children FROM Parent parent LEFT JOIN p.children children GROUP BY parent maybe it would be good if it will return a list of Object[2], where the second object is a list of children of a parent. Because creating a query to get a list of parents, then fetching children list for each parent - not a good idea.

Thank you.

edit
delete
#2

You may use JOIN FETCH for this purpose.

ObjectDB Support
edit
delete

Reply

To post on this website please sign in.