Pagination Mode

If you have access to a large number of employees, you can run specific Dataviews and have the all the data provided in the user interface. The Dataviews automatically switch to pagination mode when the employee limits are exceeded, allowing the application to render all data into separate pages.

Pagination mode is activated under specific conditions for the following Dataviews:

  • Business Structure Dataview– Pagination mode is activated when the Dataview returns more than 300 locations. The number of locations per page is a maximum of 100, but could be less to depending on the volume of data returned.
  • Business Structure Time Series Dataview– Pagination mode is activated when the Dataview returns more than 300 locations. The number of locations per page is a maximum of 25, but could be less depending on the volume of data returned.
  • Employee Dataview– Pagination mode is activated when the Dataview returns more than 3500 employees. The number of employees per page is a maximum of 1000, but could be less depending on the volume of data.
  • Employee Time Series Dataview– Pagination mode is activated when the Dataview returns more than 400 employees. The number of employees per page is a maximum of 100, but could be less depending on the volume of data.

For dataviews that do not exceed the static limits of 300 locations or 3500 employees but return a large volume of data, see Dynamic pagination.

Note: You can initiate the Dataview download functionality at any point.

Expanded Select All capability

Dataview pagination mode provides the ability to select all employees across all pages that are returned in a Dataview and perform an action, for example, approve timecards.

  • Click Tap Select All in a Dataview to select all records across all pages.
  • After selecting all, you can use the existing Action Bar to perform limited actions.
  • The count of employees across all pages as returned by the selected hyperfind/location appears in the banner at the top of the page.

Supported Actions

The following actions are supported for multiple employees across all pages in Pagination mode:

Category

Action

Approval

Approve Timecard

Approval

Remove Timecard Approval

Approval

Sign-Off

Approval

Remove Sign-Off

Approval

Lock Payroll

Approval

Enable Edits

Track Time

Add Punch

Track Time

Delete Punch

Track Time

Add Paycode

Track Time

Delete Paycode

Track Time

Add Pay from Schedule

Track Time

Delete Pay from Schedule

Track Time

Calculate Employee Totals

Accruals

Reset Accrual Balances

Attendance

Apply Rules

Attendance

Complete Actions

Attendance

Update Balances

Attendance

Reset Balances

Attendance

Modify Markers

Leave

Add Leave Time

Not supported for all employees

The following actions are not supported for all selected employees across all pages by category:

Category

Action

Leave

Add Case

People

Add

People

Edit

People

Duplicate

Not supported for more than 3500 employees

The following actions are not supported for more than 3500 employees.

Category

Action

Accruals

Payout Accruals

Accruals

Update Earned Accruals

Accruals

Suspend and Reinstate Accruals

People

Add Employment Terms

People

Remove Employment Terms

People

Delete

Select All within a page

When viewing an Employee or Employee Time Series Dataview or a Business Structure Time Series Dataviews in Pagination mode, you can select all employees within the page being viewed.

  • Click Tap Select All .

  • Click Tap Select All on this page.

  • Click Tap Select All again to Unselect All the selected records.

The count of employees on the current page appears in the banner at the top of the page.

Functionality

The following functionality applies to Pagination mode.

  • Show/Hide Data columns
  • Right-click actions, for example, the Go to control.
  • Select employees and perform actions
  • Page filter
  • Employee name page control

Page filter

While in Pagination mode, you can filter on the page that you are viewing in the Dataview. Use the Show Filters Row or Refine control to apply one or more filters. When you navigate through the Dataview, the filter carries over from page to page.

Note: This is an ad hoc filter and cannot be saved. You can filter and save all pages outside of Pagination mode if you have less than 3500 employees.

Paging control

While in Pagination mode, you can navigate between pages to view data for all employees or location names, using the paging control that is located at the bottom of the Dataview.

  • Click Tap the right caret to page through the Dataview, or enter a number in the number box.
  • Depending on the type of Dataview, on each page you can view either:
    • The first and last name of the first employee and last employee in Employee Dataviews.
    • The first and last name of the first location and last location in Business Structure Dataviews.
    • To the left of the paging control, the first and last employee or location names on the page appear in blue.
    • Select the down caret next to the names. The first and last employee or location names for all the pages in the Dataview are displayed. You can select any of the items and navigate to that page.

Limitations

The following limitations apply to Pagination mode.

  • Some Dataview functionality is disabled in Pagination mode including:
    • Sorting
    • Group By
    • Calculate (SUM, AVG, MIN, MAX, COUNT)
    • Charting
    • Save (Personalization)
    • Print
    • Export
    • If you have access to more than 3500 employees and create a Chart tile on a Home page, the associated Dataview must be personalized to use a hyperfind that does not trigger pagination mode or the chart will not render.

  • Pagination mode is not available in mobile.

Dynamic pagination

For dataviews that have a large volume of data but do not exceed the static pagination limits of 300 locations or 3500 employees, a calculated threshold is used that, when exceeded, enables dynamic pagination. The threshold is a variable limit that is dependent on the number of columns configured in the dataview. It is calculated using the following equation:

10,000,000/ the number of columns in the dataview = the calculated threshold

If the calculated threshold is less than then system setting threshold of 500,000, then the calculated threshold is used as the limit. The limit is rows per page.

Note: There are two or three hidden columns (typically three) added to every dataview. These columns are not seen in the dataview but are included in the column count. If you calculate your dataview’s threshold, add two or three to the configured column count.

Dynamic pagination

Dataviews that exceed the calculated threshold open in dynamic pagination mode, which differs from the static pagination mode used for dataviews that exceed the static limits (300 locations or 3500 employees). Dynamic pagination behavior:

  • Page count grows as you page through the dataview and the data renders. When you refresh the dataview, the initial page count appears.
  • Filters apply across the whole response and the page count adjusts accordingly so there are no blank pages.
  • Filters can reduce the response to below the threshold and allow, for example, charts to render.
Note: Rarely, there may be times when both pagination modes occur in a Datavew. For example, you have 4,000 employees in the hyperfind and one page of 1,000 employees exceeds the volume limit. If this occurs, the page is split in two dynamically.