See Also

Searching Within a Grid

The filter row at the top of a grid allows you to search for data within the grid.  

 

white_list_48.png

To search using the filter row:

  1. A filter row will appear at the top of any grid that supports filtering.

    FilterRow.jpg

  2. Enter any search criteria you desire into any column in the filter row.  The <, >, and = operators are allowed.  In the following example, entering "Plate" into the Title filter column shows only the items that contain the word "Plate".   

    Filtered.jpg

    The following table provides examples of other supported filtering methods.

Sample Results
>P will show all rows where the column data starts with a letter Q or higher
>=P will show all rows where the column data starts with a letter P or higher
<2 will show all data with values less than 2
<=2 will show all data with values less than or equal to 2
=Santa Fe will show only the rows where the column data is exactly equal to "Santa Fe"
<>Under Construction will show all rows where the column data doesn't equal "Under Construction"
Erie* will show all rows where the column data starts with "Erie"
*Plate will show all rows where the column data ends with "Plate"
a AND b will show all rows where condition a and b are both found
a OR b will show all rows where condition a or b is found
"Brand New" OR "Never Used" will show all rows with either string "Brand New" or"Never Used"
"3/8"" Drill" when needing to search on a string containing double quotes, double up the double quote and place the entire string in double quotes.  This will find a title containing: Stainless Steel 3/8" Drill Bit
1[_]2 The special character underscore (_) must be escaped by square brackets.  The search on the left will find occurrences of 1_2 in the column.
100[%]

The special character percnent sign (%) must be escaped by square brackets.  The search

on the left will find occurrences of 100% in the column.

 

To perform more complex searches that can be saved, please see Searches and Saved Views.