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 14: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 15:24

James Sutherland

Messages: 1939
Registered: July 2009
Location: Ottawa, Canada

Senior Member

You need to do a second query with count.

James : Wiki : Book : Blog : Twitter

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: Sat Apr 27 00:00:28 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter