Gavin King ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiMTk5ODUyZjJm... ) / New Feature ( https://hibernate.atlassian.net/browse/HHH-16931?atlOrigin=eyJpIjoiMTk5OD... ) HHH-16931 ( https://hibernate.atlassian.net/browse/HHH-16931?atlOrigin=eyJpIjoiMTk5OD... ) add SelectionQuery.getResultCount() and Pager.getPageCount() ( https://hibernate.atlassian.net/browse/HHH-16931?atlOrigin=eyJpIjoiMTk5OD... ) Issue Type: New Feature Assignee: Unassigned Components: query-criteria, query-hql, query-sql Created: 12/Jul/2023 06:08 AM Priority: Major Reporter: Gavin King ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) For query pagination users sometimes want a convenient way to just get the number of pages by running a count query. Of course it’s not difficult to implement this on top of our APIs, but since every framework built on top of Hibernate reimplements this, we may as well provide a standard implementation. To be clear, we would implement this by: * messing with the SQM tree for HQL and criteria queries, and * by wrapping in an outer select for native queries (or, perhaps, in the case where there’s only one select keyword in the query, by just replacing the select list). ( https://hibernate.atlassian.net/browse/HHH-16931#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16931#add-comment?atlOrigin=ey... ) Get Jira notifications on your phone! Download the Jira Cloud app for Android ( https://play.google.com/store/apps/details?id=com.atlassian.android.jira.... ) or iOS ( https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=Em... ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100231- sha1:2d13be9 )