WITH pagedQuery AS
(
SELECT ROW_NUMBER() OVER (SORTBY(PRODUCTION_ENTITY_NAME DESC)) p2RowNumber, PRODUCTION_ENTITY_NAME, PRODUCTION_DATE, PROD_GAS_ALLOC_GROSS_VOL, PROD_OIL_ALLOC_GROSS_VOL, PROD_WATER_ALLOC_GROSS_VOL
FROM PRV_PRODUCTION_METRICS
where PRODUCTION_ENTITY_NAME in (PARAMS(names,entity))
and PRODUCTION_DATE >= PARAM(prodStartTime,datetime)
and PRODUCTION_DATE < PARAM(prodEndTime,datetime)
and UPPER(READING_TYPE) = PARAM(readingType,string)
)
select (select count(1) from pagedquery) P2TOTALROWCOUNT, pagedQuery.*
FROM pagedQuery WHERE p2RowNumber BETWEEN FIRSTROW() AND LASTROW()<\/code><\/p>\nTo start with, create a datasource in P2 Server Management Studio\u00a0that contains the above query.<\/p>\n
Next up, go ahead and create a new page in Explorer Studio. Make a grid layout with 2 rows (add some padding), and add the above query as a dataset on the page.<\/p>\n
![\"pagingdata\"](\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/04\/pagingdata-800x584.png\")
<\/a><\/p>\nThe presence of the Enable Server Paging check box in the component editor indicates that Studio has detected you are using a query which supports server paging.\u00a0<\/p>\n
You can go ahead and use the query without paging, but the purpose of this example is to use paging with the explorer paging toolbar, so select the check box. You will now see that additional parameters become available. Fill out all the parameters in the component editor as follows:<\/p>\n
\n- Total Row Count<\/strong>: totalNumberRows<\/li>\n
- PageNumber<\/strong>: pageNumber<\/li>\n
- PageSize<\/strong>: pageSize<\/li>\n
- names<\/strong>: BOSSIER 1-1, BOSSIER 2-1, BOSSIER 3-1, BOSSIER 4-1, BOSSIER 5-1, BOSSIER 6-1<\/li>\n
- prodStartTime<\/strong>:\u00a001\/01\/2012 12:00:00 AM<\/li>\n
- prodEndTime<\/strong>:\u00a001\/12\/2012 12:00:00 AM<\/li>\n
- readingType<\/strong>: DAILY<\/li>\n<\/ul>\n
The Total Row Count<\/em> parameter is an additional parameter which belongs to the dataset and which is required by the Paging Control. This parameter specifies the event name which is to be published with the total number of rows from the query execution. This allows the Paging Control to calculate the number of pages available. This parameter is not a query parameter on Server.
PageNumber controls the page number we are requesting, and PageSize controls how many items we want to request on each page.<\/p>\nNow, let's set defaults for the pageNumber and pageSize. This is required for pageSize as the Paging Control does not output the page size (although it could if you used a Combo Box<\/a> to drive the page size).\u00a0<\/p>\n![\"pagingdefaults\"](\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/04\/pagingdefaults.png\")
<\/a>\u00a0<\/p>\nSet Event Defaults as follows:<\/p>\n
\n- pageNumber<\/strong>: 1<\/li>\n
- pageSize<\/strong>: 10<\/li>\n<\/ul>\n
Now let's drag and drop a Paging Control onto the page and configure it as follows:<\/p>\n
![\"\"](\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/04\/pagingconfig1-800x348.png\")
<\/a><\/p>\n <\/p>\n
\n- Page Number<\/strong>: pageNumber<\/li>\n
- Page Size<\/strong>: pageSize<\/li>\n
- Total Record Count<\/strong>: totalNumberRows<\/li>\n<\/ul>\n
Now let's see this thing at work.<\/p>\n
Drag and drop a Dataset Table onto the page and configure it\u00a0as follows:<\/p>\n
![\"pagingdata\"](\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/04\/pagingdata.png\")
<\/a><\/p>\n