Table of Contents

Grid View

Cory M. Updated by Cory M.

The Grid View allows for some key features that will make understanding your data much easier:

Basic Filters

Below almost all column headers are fields where the user can set a filter to view only specified records. This may be a drop-down menu of pre-defined criteria, a text input box, or a date selector. When a filter has been entered, the user must hit enter or click "Search" before it is applied to the Grid View.

Filters also affect the Export feature described below.
Text Columns

Text columns are typically case-insensitive and can be filtered with a simple text match. See Advanced Grid Filtering for a guide to using the many advanced search capabilities that text fields support.

The text inputs perform a "prefix match" by default (equivalent to query*). To search anywhere in a text field use a wildcard before and after your query (e.g. *query*).
Options Columns

Columns which use a select box for filtering also support selecting multiple options by clicking the + button below the field. Hold "Ctrl" while selecting options to select multiple options at once or use "Shift" to select a range of options.

Click "Reset" to clear all search filters and return the grid to the default state.

Date/Time Columns

Timestamp columns can be filtered with a From and To date, but you can also add a time component to your filter by clicking on the "From" and "To" labels:

If a time component is not used the filter condition will be interpreted as:

  • From: "greater than or equal to the From date at 00:00:00"
  • To: "less than or equal to the To date at 23:59:59"
Date and time filters are affected by the user's timezone. Since different users can have different effective timezones, it is possible that two users using the "same" filters can get different results if not accounting for their relative timezone difference.
Numeric Columns

Numeric columns can be filtered with a range which is inclusive for both the From and To values.

Filters on columns for measurements will always apply using the default unit of measure even if the displayed value is in a different unit of measure.
Mass Actions

You can check a box on a mass-action enabled grid and then change the column filter to Any, Yes, or No where "Yes" means the checkbox is checked and "No" means it is not checked.

This allows you to, for example, check all rows for a large search excluding only certain rows:

  1. Search for a given criteria
  2. Check the boxes of the records you want to exclude
  3. Choose "No" in the checkbox column and update your search
  4. Click Select All - the items that were checked in step 2 will not be included in the mass action

Exporting Data

Most grids allow for the data to be exported to CSV or Excel XML. To download an export file, click the dropdown next to the export button, choose a data set and file type, and click Export.

Any filters applied will affect the exported data, but you must click Search to apply the filters before clicking Export.

Mass Actions

Mass actions allow you to affect any number of selected items in a Grid View.

  1. To use this feature, select the items using the check boxes on the left-most column in a Grid View or use Select All or Select Visible to choose one or more items to which your action will apply.

  1. Then click the menu next to “Actions” on the right side of the Grid View to see the action that can be applied and choose the appropriate action. Some actions may have additional fields that appear when chosen.
  1. After selecting an Action click Submit.
You can change the value at the top of the checkbox column from "Any" to "Yes" or "No" to filter the grid by only those rows that are either checked or unchecked.

How did we do?

Advanced Grid Filtering