|
||||||||||
| PREV NEXT | FRAMES NO FRAMES | |||||||||
| Packages that use PageControl | |
|---|---|
| org.rhq.core.domain.criteria | |
| org.rhq.core.domain.server | |
| org.rhq.core.domain.util | |
| Uses of PageControl in org.rhq.core.domain.criteria |
|---|
| Fields in org.rhq.core.domain.criteria declared as PageControl | |
|---|---|
protected PageControl |
Criteria.pageControlOverrides
|
| Methods in org.rhq.core.domain.criteria that return PageControl | |
|---|---|
PageControl |
GenericDriftCriteria.getPageControlOverrides()
|
PageControl |
BaseCriteria.getPageControlOverrides()
|
PageControl |
Criteria.getPageControlOverrides()
|
PageControl |
GenericDriftChangeSetCriteria.getPageControlOverrides()
|
| Methods in org.rhq.core.domain.criteria with parameters of type PageControl | |
|---|---|
void |
GenericDriftCriteria.setPageControl(PageControl pageControl)
|
void |
BaseCriteria.setPageControl(PageControl pageControl)
|
void |
Criteria.setPageControl(PageControl pageControl)
If the pageControl is set, then this criteria object will completely ignore any calls made to setPaging(pageNumber, pageSize) as well as addSortField(fieldName), which is useful from a server-side calling context where the PageControl object will already have been created for you by the extensions at the JSF layer. |
void |
GenericDriftChangeSetCriteria.setPageControl(PageControl pageControl)
|
| Uses of PageControl in org.rhq.core.domain.server |
|---|
| Methods in org.rhq.core.domain.server with parameters of type PageControl | |
|---|---|
static String |
PersistenceUtility.addH2NativePagingSortingToQuery(String query,
PageControl pageControl)
|
static String |
PersistenceUtility.addOracleNativePagingSortingToQuery(String query,
PageControl pageControl)
|
static String |
PersistenceUtility.addPostgresNativePagingSortingToQuery(String query,
PageControl pageControl)
|
static String |
PersistenceUtility.addSQLServerNativePagingSortingToQuery(String query,
PageControl pageControl)
Note: always put the rownum column at the END of the columns, so that code which relies on index-based access to the result set data doesn't break Method 1: SELECT outerResults.* FROM ( SELECT innerResults.*, ROW_NUMBER() OVER( {orderByClause} ) AS rownum FROM ( {queryWithoutOrderBy} ) AS innerResults ) AS outerResults WHERE rownum <= maxRowNum AND rownum >= minRowNum The above method fails in circumstances where the orderByClause is built up with aliases that aren't in the explicit select list returned from queryWithoutOrderBy Method 2: Fix above shortcomings by pushing the orderByClause into the actual select list SELECT singleResults.* FROM ( {queryWithoutOrderBySelectList} , ROW_NUMBER() OVER( {orderByClause} ) AS rownum {queryWithoutOrderByRestOfQuery} ) AS singleResults WHERE rownum <= maxRowNum AND rownum >= minRowNum Actually, both of the above methods have small flaws. |
static String |
PersistenceUtility.addSQLServerNativePagingSortingToQuery(String query,
PageControl pageControl,
boolean alternatePagingStyle)
|
static PageList |
PersistenceUtility.createPaginationFilter(EntityManager entityManager,
Collection collection,
PageControl pageControl)
Creates and executes a filter query for a collection relationship. |
static Query |
PersistenceUtility.createQueryWithOrderBy(EntityManager entityManager,
String queryName,
PageControl pageControl)
Used to create queries to use with the PageControl objects. |
static void |
PersistenceUtility.setDataPage(Query query,
PageControl pageControl)
|
| Uses of PageControl in org.rhq.core.domain.util |
|---|
| Subclasses of PageControl in org.rhq.core.domain.util | |
|---|---|
class |
UnlimitedPageControl
A page control that shows all results. |
| Methods in org.rhq.core.domain.util that return PageControl | |
|---|---|
static PageControl |
PageControl.getExplicitPageControl(int firstRecord,
int recordCount)
|
PageControl |
PageList.getPageControl()
|
static PageControl |
PageControl.getSingleRowInstance()
|
static PageControl |
PageControl.getUnlimitedInstance()
|
| Methods in org.rhq.core.domain.util with parameters of type PageControl | |
|---|---|
void |
PageList.setPageControl(PageControl pageControl)
|
| Constructors in org.rhq.core.domain.util with parameters of type PageControl | |
|---|---|
PageList(Collection<? extends E> collection,
int totalSize,
PageControl pageControl)
|
|
PageList(Collection<? extends E> collection,
PageControl pageControl)
Used to represent a result set when the cardinality of the data is not needed |
|
PageList(int totalSize,
PageControl pageControl)
Used to represent the cardinality of a result set without when the data is not needed |
|
PageList(PageControl pageControl)
|
|
|
||||||||||
| PREV NEXT | FRAMES NO FRAMES | |||||||||