What would you like to know more about?

Data Grid

Once you click a page on the main menu, a data grid displays the records available on that page. The data grid looks like a spreadsheet of columns and rows, which is ideal for maximum data visibility. Each row represents a specific record on that page, and each column displays a certain field related to that record. When scrolling, you can visually see the first 1,000 records on a page (but you can search for, select, report on, and more with records beyond that 1,000 mark).

You can use view rules to color-code fields to draw attention where you need it most. And don't miss that the select boxes stay visible when you scroll!

Gif showing examples of view rules in a grid format

Views

The top center of the data grid displays the view drop-down. A view is a dynamic filter of the records on a page (for example, "BG Checks by Date Submitted"). Each page's data grid initially displays a default view, but you can use the view drop-down list to change the view.

Selections

The bottom right of the data grid displays the selection drop-down. A selection is a static gathering of records. Each page's data grid initially displays the All Records selection, but you can use the selection drop-down list to change the selection.

Record Counts

The bottom of the data grid displays record counts. The bottom left shows the total number of records based on the chosen view or search term.

Columns

You can do the following with the columns in the data grid:

  • Reorder: The columns on the data grid display in a certain order based on the specific view. To reorder the columns on the data grid, place your cursor on the column header of the column you want to move and click and drag the column header to the desired place.
  • Sort: Typically the data grid sorts by the first column (sorted descending if the column contains dates, and otherwise sorted ascending) by default, unless a custom view applies a custom sorting value.
  • Resize: The columns on the data grid default to a certain size. To resize the columns on the data grid, place your cursor on the seam of the column you want to resize. When the arrow icon appears, click and drag the column seam to the desired size.

These changes save per workstation and per page as part of your browser's cache. If you clear your cache or use a different browser, the system won't remember the customization you applied.

Troubleshooting

Data grid not loading as expected? Give these a try:

  • User Account: Make sure you are logged in to your own User account. If you are impersonating a user or are logged in with a different User account, different Security Roles could restrict access to the page and/or view you are trying to access.
  • Browser Issues: Clear your browser cache and local storage to resolve any browser issues. For more information, see Browser Issues.

If this doesn't work, ask your SPoC for help.