Welcome,

I am trying to learn Criteria API with demo application.
I have two many-to-many bidirectional association:

class Event {
...
private Set<Person> participants;
...
/* getters and setters */
}

class Person {
...
private Set<Event> events;
...
/* getters and setters */
}

They're mapped with many-to-many almost like in tutorial and everything works
great.

But how can I retrieve list of people ordered by events count?
With HQL it looks something like this

select person from Person person order by events.size

and works.

Using Criteria API I can order only by properties(?). Is the only solution then to sort
the list in memory after retrieval?

Thanks for help,

Mike

But you can insert a calculated one in the Event object and then you can make criteria queries on it.

I have the same problem. I want to sort with the collection size property.

You could use the size function.

This solution can be help:


Can we use size function with the Criteria API to sort ?

Do you have any examples ?

Thanks.

I have also read that we can use Projection to solve this problem ? Any ideas about this ?