You can configure the maximum number of records that appear on-screen within a List view. If the number of records in the view exceeds the limit, Aptify creates additional pages as necessary to hold all of the records. This feature is particularly useful when navigating List views that contain a large number of records.
This topic covers the following sub-topics:
Note to Administrators
Paging automatically adds an Order By clause to the view's SQL statement. This may conflict with any statement you write in Advanced SQL. In this case, disable the Paging option for the Advanced SQL view.
Configuring the List View Paging Options
In the Aptify Desktop client, the List View Paging configuration options appear on the Paging tab of the View Properties dialog. By default, Paging is enabled with a default page size of 250 records.
In the 6.0 version of the Aptify web interface, the ability to set the number of records appear on a page can be set on the Advanced > Paging tab. In 5.5.4 and earlier releases of the Aptify web interface, the paging information for a view can be viewed, but the values cannot be modified.
The Rows Per Page values set in each interface applies only to that interface. For example, changing the Rows Per Page for a view opened in the web interface to 30 does not change the number of records per page displayed when that same view is opened using the Desktop client.
To change the maximum number of records per page, enter a new value in the Paging Size field and click OK to save the view. The figure below shows a view with a Page Size that has been changed from 250 to 25.
Default and Max Values in Aptify Web
When using the Aptify web interface, the default number of pages is 25 and 250 is the maximum number of pages. If a value larger than 250 is entered, an error is displayed.
To disable the Paging feature, clear the Enable Paging option and click OK to save the view. Note that the Paging Size field becomes unavailable when Paging is disabled.
Navigating List View Pages with the Paging Option Enabled
This topic describes how to navigate list view pages when paging is enabled, broken down by interface:
Aptify Web Interface
In Aptify 6.0, the Aptify web interface supports the ability to modify the paging settings for a view. Paging is enabled when Enable Paging option is selected in the Advanced >Paging tab of a view's properties. See Configuring the List View Paging Options for more information.
The view's footer reports the link to the current page displayed in bold, links to each page, and the total number of records in the view.
The view footer has a limit of five links to a page. When there are more than five pages in a view, an ellipsis link appears in the footer that when clicked, the next set of five-page links are loaded.
The footer also includes three arrows, which a user can click to move between pages:
- Click > to move to the next page.
- Click < to move back a page.
- Click |< to return to the first page.
Aptify Desktop Client
In the Aptify Desktop client, paging is enabled when Enable Paging option is selected in the Paging tab of a view's properties. See Configuring the List View Paging Options for more information.
The view's footer reports the current page displayed, the total number of available pages, and the total number of records in the view. The footer also includes four arrows, which a user can click to move between pages:
- Click |<< to return to the first page.
- Click << to move back a page.
- The current Page number is displayed in between the arrows.
- Click >> to move to the next page.
- Click >>| to move to the last page.
Also, a user can jump to a specific page by following these steps:
- Click the current page in the footer of a view with paging enabled to open the Switch to Page dialog.
- Enter the page number to display and click OK.
- The view displays the specified page.
Comments
Please sign in to leave a comment.