Navigation & Record Selection

Any page that presents more than one record will have navigation actions. The following screen shot shows an example of the navigation actions available for a grid of records. These actions may not be enabled every time a page is viewed. The application only activates them when there are more records after (next and last) or before (first and previous) the current record(s) displayed.

• Advantage indicates the total count of records returned along with the set of records that are currently displayed on the grid, for example,1 -20 of 49 or 21 - 41 of 49. This feature is available on all grids within the application, unless disabled through metadata configuration change.

• By default, grids only display 20 records at a time; however, you can change the number of records that are displayed in the grid by selecting one of the View per Page options: 20, 50 or 100. The above example has 20 selected. If you select 50 on one page, then the value changes to 50 on all pages that have the View per Page option. After you log out of Advantage, the value defaults back to 20. This feature is available on all grids within the application, unless disabled through metadata configuration change.

For grids where the system cannot determine the actual record count or page count, a “+” suffix is displayed after the record and/or page count.  This indicates that  there are more than the indicated number of records or indicated number of pages. The following example shows how the plus (+) sign is used to indicate for a grid that has more than 20 records and more than 1 page.

• Additionally, a site has the ability to add a pagination option of 500 by setting the enable_500_pagination_option property to true in the ui_preferences.conf file. If the option is enabled, the pagination options for all grids will be 20, 50, 100, and 500. Selecting the 500 pagination link allows users to view 500 rows on the standard grid. Administrators can refer to the “UI Preferences Configuration” topic in the CGI Advantage System Administration Guide, for more information.

• A site has the option to enable more than 500 records to be viewed on a grid page if the showViewAllonGrid property is set to true in the metadata for the grid and the viewAllRecordsOnGrid feature flag is enabled. The view_all_max_row_count property in the ui_preferences.conf file indicates the maximum numbers of records that can be displayed in a grid. The default value for this property is 1000. The grid pagination displays a numbered link based on the value of this property and the pagination link is enabled if there are more than 500 records returned from the search results. For example, if the value is 1000, then a 1000 link is added in the grid pagination and up to 1000 records are returned when the 1000 link is selected. The value of this property should be greater than 500 and must be numeric. When a pagination link greater than 500 is selected, the grid’s view changes and some of the Advanced Grid features are available. Refer to the “Advanced Grid” topic for more information.

• Navigation actions are provided that assist you in navigating between the first (<<), previous (<), next (>) and last (>>) record in the grid.

• Some pages allow you to export selected records or all of the records in the grid to a CSV file. Refer to the "Export Grid Results" topic for more information.

• A Show/Hide icon appears above the grid, which allows you to show/hide the toolbar and pagination area of read only grids. By default, the toolbar and pagination area is displayed for all grids; however, you can select the Hide Toolbar and Pagination field on the Preferences tab of Account Settings via User Profile, if you want to hide the toolbar and pagination area of read only grids on all pages by default. You can then show the toolbar and pagination area of a read only grid for a specific page by selecting the Show/Hide icon above the grid. This setting will remain for that page until you log out, then the default specified on your Account Settings for the application will take precedence the next time you log in and access the page. Refer to the “Account Settings” topic in the CGI Advantage Getting Started User Guide, for more information on the Hide Toolbar and Pagination field.

• Additionally, Advantage Framework supports the column pagination feature that can be enabled on pages that have a need to apply pagination at the column level. For example, the Salary Table Amounts (STBL) page on the Salary Table Maintenance (STBL) page has 100s of columns. To drive optimized performance on this page, the column pagination feature is enabled at the page level, so that users can work through a set of columns (10) at one time and go to next 10 columns, enter data and so forth.

How to enable this feature?

Sites can enable the ENABLE_COLUMN_PAGINATION parameter on the ERP Application Parameters (ERPCTRL) page. If this global parameter is set to true, then the column pagination feature is enabled only on those pages where the page metadata property "enableColumnPagination" is true.

How the feature works?

The column pagination feature works only with the standard grid and is currently enabled for the Salary Table Amounts (STBL) page of the Performance Budgeting application. Column Pagination allows users to do pagination at the column level. For example, columns 1-10 of 200, and has the ability to do first, previous, next, and last paginations at the column level.

At the end of navigation, a record is often selected to copy, update, and sometimes delete. The application provides different methods of identifying a selected grid record. The most common is the placement of a check mark to the left of the record or records that you want to select. The last record selected is highlighted in dark blue and the other records selected are highlighted in yellow. The other method is to check the Selection check box in the grid header, which selects all records on the page. On scalar-only pages where navigation is allowed, selection of a record happens when navigation ends on a record. For pages that have a scalar tab with a grid, the information shown in the scalar changes to that of the selected record automatically.

A Calendar window is accessed by selecting the calendar () icon. After selecting a date, the calendar window closes and the date that was chosen is populated in the date field.

Some date fields also capture the time. After selecting a date and a time, click outside of the calendar window and the date and time selected are entered in the corresponding field.

Many fields in Advantage have pre-defined values that are available in a drop-down menu by selecting the drop-down arrow in the field's text box. You can select a value using the pointer or by using the up and down keys to highlight a value. When a value is selected by a left mouse click, the drop-down disappears and the selected value is shown in the field. When selection is done by the up and down keys, a user must select the Enter key to select a value.

The Pick List icon is available for many fields in Advantage to assist with searching and selecting a valid value for the field.

After selecting the Pick List icon, a modal window appears that displays records that can be selected. You can narrow search results by entering values in the search fields. Once the desired record is chosen, select the OK button. This closes the pick list modal window and enters the selected value in the pick list field.

The Change Employee () icon transitions you to a search pop up that allows you to search for and select an employee to view. Select the row for the Employee ID you wish to select and then OK to return to the previous page.