{"id":15376,"date":"2016-06-08T11:39:44","date_gmt":"2016-06-08T03:39:44","guid":{"rendered":"http:\/\/localhost\/help\/?page_id=15376"},"modified":"2017-12-14T14:36:48","modified_gmt":"2017-12-14T06:36:48","slug":"paging-control-4-3-2","status":"publish","type":"page","link":"https:\/\/oihelp.corporate.ifs.com\/help\/p2-explorer\/explorer-studio\/controls\/paging-control\/paging-control-4-3-2\/","title":{"rendered":"Paging Control (4.3.2)"},"content":{"rendered":"\n

This article applies to the Paging Control in versions 4.3.2 and earlier of P2 Explorer. For help on the latest version, see Paging Control<\/a>.<\/p>\n

Overview<\/h3>\n

The Paging Control allows page designers to split up large amounts of tabular data into smaller chunks, or pages. This allows\u00a0the user to move through those pages to view the data in a table. This is a useful way of displaying many rows of tabular\u00a0data in a small space.<\/p>\n

Note: For this component to work with a dataset, paging must be enabled<\/a> on the dataset.\u00a0<\/p>\n

The following screenshot shows a Paging Control being configured:<\/p>\n

\"\"<\/a><\/p>\n\n\n\n\n\n
Page Number<\/strong>:<\/td>\nThe number that is published when the user clicks through the page control. This is effectively the page of data that the user is viewing. This event is a parameter of the paging-enabled dataset.<\/td>\n<\/tr>\n
Page Size<\/strong>:<\/td>\nThe\u00a0number of rows of data to display in the table.\u00a0This event is a parameter of the paging-enabled dataset.<\/td>\n<\/tr>\n
Total Record Count<\/strong>:<\/td>\nThe total number of records in the dataset, rounded up. This is an attribute of the paging-enabled dataset.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
\n

Tutorial<\/span><\/h3>\n
\n

The Paging Control is a useful component that enables users to move through pages of data displayed in a table. However it will only work on datasets that have been enabled for paging.\u00a0This is done by modifying the dataset query in P2 Server. When the dataset is paging enabled, the configuration panel for the dataset will display an addition section \"Query Paging<\/strong>\".<\/p>\n

\"paged1\"<\/a><\/p>\n

The important configuration parameters to note for paged datasets are:<\/p>\n\n\n\n\n\n\n\n
Total Row\u00a0Count<\/strong>:<\/td>\nThe total number of records in the dataset, rounded up. This is always an event that publishes an attribute of the paging-enabled dataset. This event should only be set for page enabled datasets.<\/td>\n<\/tr>\n
Enable Server Paging<\/strong>:<\/td>\nSelect this check box to indicate that you want to take advantage of dataset paging.<\/td>\n<\/tr>\n
Page Number<\/strong>:<\/td>\nThe page number to display when the display is first opened.\u00a0<\/td>\n<\/tr>\n
Page Size<\/strong>:<\/td>\nThe\u00a0number of rows of data to display in the table.\u00a0<\/td>\n<\/tr>\n
SortBy<\/strong>:<\/td>\nThe\u00a0name of the column in the dataset by which to sort the table. Columns containing text will sort alphabetically, those containing numbers will sort numerically, and those containing dates will sort chronologically.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

In this tutorial, we\u2019ll look at adding a Paging Control component that will display pages of data in a large dataset table.<\/p>\n

\"pagingshow\"<\/a><\/p>\n

Let\u2019s go through this process, step-by-step.<\/p>\n

\n

Step by Step: Displaying a Paging Control for a Large Dataset\u00a0Table on a Page\u00a0<\/span><\/span><\/span><\/h3>\n

Before you start, open a new tab in Explorer and click the \u201cCreate a New Page in Studio Mode\u201d thumbnail. Choose the grid<\/a>\u00a0layout \u2013 you can adjust the rows and columns if you like but it\u2019s not important for this exercise.<\/p>\n

You will need to adjust the configuration to suit your data at your site.<\/p>\n

Step 1. Add the\u00a0source data<\/strong><\/p>\n

\"pagingdata\"<\/a><\/p>\n<\/div>\n

\n

As the aim here is to display tabular data, the first thing we want to do is add\u00a0the data<\/a> we want to display.\u00a0<\/p>\n

The important thing to note here is that the dataset must be enabled for paging<\/strong>. This is done by modifying the dataset query in P2 Server to enable it for paging.<\/p>\n