Orientation, Grids, Filtering Rows
|

You can filter rows (records) by any of the values in any of the columns in your grid.

To Filter data in your grid

Right-click anywhere in the grid and choose Show Filter Row to show a new row above the grid with filtering options for each column.

Gris, Filtering Records

The icon at the left of each column's Filter Row allows you to choose what type of filter you wish to apply to that column. It will differ depending on the data type in that column. For example a Date or Value column will have =,<,> etc., whereas a Text Field will have Starts With, Contains, Ends With etc. Select the filter type and then type in the filter criteria in the yellow space beside the filter icon. Your grid will automatically apply the filter as you type in your criteria.

To remove all Filters

Click on the Clear Filters icon at the left of the Filter Row.

To remove filters on individual columns

Click on the Clear Filters icon in the column or delete the filter text from the Filter Row.