Criteria API

[Mateusz Kwasniewski]

I'd like to get a list of subcategories in order (asc or desc) specified by the number of books in a subcategory. Can anyone help me to figure out how can I do it using Hibernate Criteria API?

Here is the code of the Subcategory class:

  public class Subcategory {
private int id;
private String name;
private Set<Book> books = new HashSet<Book>();
        //getters and setters
        }
  

Thanks in advance

[Edvins Reisons]

What if you approach this matter from the Book end of the association?
Group them by Subcategory and order by rowCount.

[saranga rao]

hi ,

Might it look like this.......

List lst = session.createCriteria(SubCategories.class).createAllias("Book","bk").add(Expression.eq("bk.id",id).add(Order asc);

May there will be change in the Allias name but the query returns list of SubCategories.....