Filtering

On the WIP user interface, you have various filtering options to find and display only the rows in the grid that meet specific criteria.

Main Column Filtering

At the top of each column, next to the column title, you can use the filter icon to select one or more values to filter the column. After selecting the required values, click Filter to apply the filter to the grid. To remove the filters, click Clear.

../_images/grid.filter.column.png

Tip

To clear all the filters applied to the grid, choose the reset Reset toolbar button.

Additional Column Filtering

In the second header row of each column, additional filtering options are available based on the type of values the column contains.

Word Filtering

If the column contains alphanumeric values, you can type part or all of the text in the search bar and use the filter button to select the required search criteria:

../_images/grid.filter.word.png

You can remove the filter using the removefilter icon.

Numeric Value Filtering

If the column contains numeric values, you can type a number in the search bar and use the filter button to select the required search criteria. You can also use the toggle button to increase or decrease the entered value.

../_images/grid.filter.number.png

You can remove the filter using the removefilter icon.

Date Filtering

If the column contains date and time, you can select the required date and time using the date selector in the search bar and then use the filter button to select the required search criteria:

../_images/grid.filter.date.png

You can remove the filter using the removefilter icon.