Skip to main content

Search and Filter Data

The Data Grid is the primary tool when exploring data. When searching and filtering for data within the data grid, the global search bar and column filters are both elements that can be leveraged to navigate data.

alt_text

The global search bar allows users to search across ALL fields for a specific term. Global search combs through the data within the entire collection and returns only records where a match is found. When searching using the global search bar, users should note that search matches against full terms (not partial matches). If partial matching is required, consider the “contains” function in the column filters.

alt_text

Column Filters​

Column filters allow for multiple filter criteria to be associated (one per column) in order to return only records matching all criteria being returned. Column filters, for example, can be applied after a global filter has been applied. Available column filters include:

  • Contains
  • Equals
  • Not Equals
  • Starts With
  • Ends With
  • Ranges

To use a column filter:

  1. Hover of the target field header (the column type will change to an arrow)

alt_text

  1. Click the arrow, select the operator from the dropdown and and define your filter criteria and select ‘Apply Filter’

alt_text

  1. To layer on another search term, simply select another column and apply the desired search.

When column filters are applied, a filter balloon is created for each filter. To remove a filter, simply click on the “X”. To clear all the search filters, simply click the “X” in each search filter balloon.

alt_text