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.
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
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)
- 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.
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.