Eclipse Community Forums: EclipseLink » When I set FirstResult and MaxResult how I can get the total ( count() )

Home » Eclipse Projects » EclipseLink » When I set FirstResult and MaxResult how I can get the total ( count() )(regardless of the first and maxResults values?)

Show: Today's Messages :: Show Polls :: Message Navigator

When I set FirstResult and MaxResult how I can get the total ( count() ) [message #533957]

Mon, 17 May 2010 10:51

No real name
Messages: 7
Registered: April 2010

Junior Member

Hi!

I have a query that I set firstResult and maxResult because I use the result in a dataTable with paginator. But I also need to know how many results, the total I have without the firstResult and maxResult params. Exist a way to get this value or I will always need to do a second query with count() ?

Report message to a moderator

Re: When I set FirstResult and MaxResult how I can get the total ( count() ) [message #533980 is a reply to message #533957]

Mon, 17 May 2010 11:24

James Sutherland
Messages: 1834
Registered: July 2009

Senior Member

You need to do a second query with count.

James : Wiki : Book : Blog

Report message to a moderator

Previous Topic:	Prevent errors in log when using drop-and-create-tables for eclipselink.ddl-generation
Next Topic:	Implementing aggregate boolean functions in JPQL?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon May 20 07:29:53 EDT 2013