CATSWeb Paging Controls
Manager Contents
User Contents
Overview

By default, data returned from a Query or SQL (such as a SQL Data Link) returns all resulting rows. When many results are returned, the query can take a long time to run and may actually time out. CATSWeb Paging Controls can be used to enable pagination for query or SQL results. When enabled, the user can navigate forward or backward in the results, 1 page at at time. Only the rows that are associated with a particular page are returned. This reduces the overhead required for long queries.

Pagination can operate on the following:
  • Display Parts - Pagination can be used in conjunction with Data, DataRow Selector, and Datasheet Display Parts. For Display Parts that use a Query as a Data Source, pagination can be enabled on either the Display Part or the Query.

    Display Part Pagination Options

  • Queries - Pagination can be used in conjunction with Standard CATSWeb Queries.

    Query Pagination Options
Pagination Settings

The following pagination settings are available.
  • Paginate Display or Paginate Results - Checking this option causes CATSWeb to use pagination for Query or SQL results that are used in selected Display Parts.
    • When enabled, only the number of records selected by the Rows per page wll be returned for a given page.
    • If pagination is enabled without setting a numeric Rows per page, pagination will be ignored and all rows will be displayed.

  • Rows per page or Number of rows per page - When Paginate Display is enabled, this setting provides the number of rows to return for each page.
    • New Display Parts that are added will use a default Rows per page of 10. Any pre-existing Display Parts (such as those from converted CATSWeb V6 databases) will not have a default Rows per page value.
    • There is no default Rows per page value on the standard Query page.
    • If pagination is enabled without setting a number of rows per page, pagination will be ignored and all rows will be displayed.
Pagination Controls

When pagination is enabled, the following controls will be present on the Display Part or Query results.

Page Options Controls
  • First Page First Page - Changes the display to the first page.
    • When on the first page, the First Page button is omitted.

  • Previous Page Previous Page - Changes the display to the previous page.
    • When on the first page, the Previous Page button is omitted.

  • pagination options jump to page Jump To Page - The Jump To Page button will change the display to the page number entered in the related Jump To Page field.
    • Entry of non-numeric values or decimals will generate an error.
    • Entry of a page number higher than the total number of pages will jump to the last page.
    • Entry of negative page numbers will use absolute value (-8 will jump to page 8).

  • Next Page Next Page - Changes the display to the next page.
    • When on the last page, the Next Page button is omitted.

  • Last Page Last Page - Changes the display to the last page.
    • When on the last page, the Last Page button is omitted.

Back to Top