Criteria get total record count

jefetech · **Joined:** Mon Jul 31, 2006 2:41 pm **Posts:** 13

I'm using Criteria for a report with lots of filters, and page flipping. For the page flipping I'm using the:

criteria.setMaxResults();
criteria.setFirstResult();

I would like to be able to display the total records for the user, however this list will just have the 25 because I'm only doing 25 per page. Is there somehow to count the total records? something like:

criteria.getTotalRecords()

I've seen some people do a criteria.list().size(), but that is horrible and I won't do that.

pasha · **Joined:** Sat Nov 27, 2004 4:13 am **Posts:** 137

If you are using Hibernate 3:

create another Criteria with the same conditions, and

Code:

criteria.setProjection(Projections.rowCount());
Integer result = (Integer) criteria.uniqueResult();

-----------
don't forget credits[/code]

deepaksurti · **Joined:** Thu May 12, 2005 5:54 pm **Posts:** 16

We have queries like this:

Code:

select title.name, title.descr, schedule.date
from title, schedule
where.....

We have a queryCriteria on which we set:

Code:

setFirstResult(n1)
setMaxResults(n2)

On queryCriteria we have projections for title.name,title.descr,
schedule.date

To get total count we need to do the following:

Code:

select count (distinct title.name || title.descr || schedule.date)

Since there is no concatenation in Projections we have created our own classes to do that.Refer to this post.
http://forum.hibernate.org/viewtopic.php?t=964506

Thus, code for above looks like this:

Code:

propertyNames = "title.name;title.descr;schedule.date";
countCriteria.setProjection(ExtraProjections.countMultipleDistinct(propertyNames))

Note queryCriteria and countCriteria are exactly the same in terms of query. Only in terms of projections they differ. They are different object instances.

Hope this helps.

Cheers.

jefetech · **Joined:** Mon Jul 31, 2006 2:41 pm **Posts:** 13

Thank you for the quick responses. This helps alot.