Group by month in Hibernate Criteria queries

Question

I am new to Hibernate Criteria Queries , I am struggling to get the count based on month.

   session.createCriteria(Task.class)                                                                           
  .add(Restrictions.eq("completed", true))                     
  .add(Restrictions.in("site", sites))  
  .setProjection(Projections.rowCount()).uniqueResult();
  //group by "completedTime"

If I have to get the count group By Month based on completedTime. How can i achieve this

Siva Kumar · Answer 1 · 2015-10-24T20:03:57.577

0

Please try below code

    Criteria criteria = session.createCriteria(Task.class);
    criteria.add(Restrictions.eq("completed", true));                     
    criteria.add(Restrictions.in("site", sites));

    ProjectionList projectionList = Projections.projectionList();
    projectionList.add(Projections.rowCount());
    projectionList.add(Projections.groupProperty("month"));

    criteria.setProjection(projectionList);
    criteria.addOrder(Order.asc("completedTime"));

You need to create projectionList to add projected column in it.

EDIT 1

projectionList.add(Projections.property("month"));

add month also in projectionList , so that you can able to retrieve the value.

edited Oct 24 '15 at 20:03

answered Oct 24 '15 at 02:34

Siva Kumar

1,983
3
14
26

Thanks a million , I have one more doubt . Is there any way can get the month name for each count – Cork Kochi Oct 24 '15 at 15:19
groupProperty return the property also in result. no need to externally mention that. – Siva Kumar Oct 24 '15 at 15:33
Can you please verify now. – Siva Kumar Oct 24 '15 at 20:05

Group by month in Hibernate Criteria queries

1 Answers1