.. _screen.grid.filter:

=========
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**.

.. image:: 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:

.. image:: 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.

.. image:: 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:

.. image:: images/grid.filter.date.png

|

You can remove the filter using the |removefilter| icon.

.. |filter| image:: images/icon.filter.png

.. |removefilter| image:: images/icon.filter.remove.png

.. |toggle| image:: images/icon.toggle.updown.png

.. |reset| image:: images/icon.reset.png