Filter the grid by a column

In the column heading cell, click the Filter button. The filter panel appears.

There are filter variations for text columns:

Date/time columns:

Duration columns (accepts integer or 2-decimal numbers):

And true/false (check box) columns:

For text, date/time, and duration columns, you can enter up to two filter criteria for the data in the column. You can also filter on two or more columns to further refine the records that are displayed in the grid.

Note: Using the Has no value filter option for a column overrides any filters applied to other columns. Because of this behavior, the Has no value filter option should only be used when filtering on a single column.

Apply a filter for a text, date/time, or duration column

1. Select a condition from one or both of the lists to configure the search. By default, the Is equal to option is selected.

2. If you are using two filter criteria:

   • Select And to filter on results that fulfill both search conditions.

   • Select Or to filter on results that fulfill either of the search conditions.

3. Enter the search criteria in the filter boxes.

   • If only using one filter criterion, leave the second filter box blank.

4. Click Filter.

   Only the entries whose data in the column on which you are filtering match the filter criteria are included in the grid.

   If the search criteria entry is not valid for the filter type, the filter is not applied.

Apply a filter for a true/false column

5. Select the is true or is false option.

6. Click Filter.

   Only the entries that match the true (check box selected) or false (check box cleared) condition on which you are filtering are included in the grid.

Clear the filter

• Click Clear.