Filtering Data

Filter Dropdown List

media_1450187865706.png

Hover over the column header and click the filter button within the column header that appears.

Creating a Simple Filter

media_1450187884925.png

Invoke the filter dropdown list containing available filter values.

Select the required filter value in the filter dropdown list.

media_1450187933973.png

For date-time columns, the filter dropdown list is displayed as a calendar.

To apply the filter, select the desired date.

The control will immediately display records which contain the selected date in the appropriate column.

To hide the filter dropdown list, click the close button .

Advanced Filter Dialog

media_1450188014504.png

Right-click any column’s header and select Filter Editor.

media_1450188029690.png

If the filter panel at the bottom is visible, click the Edit Filter button

Clearing the Filter

media_1450188073064.png

To clear the filter applied to a specific column, do one of the following:

  1. Invoke the filter dropdown list (see above), and then choose between clicking (All) or selecting (Select All) or choosing (Show All,) depending on the dropdown list type.
  2. Right-click the column header and select the Clear Filter menu item.

 

media_1450188116485.png

To clear all filter criteria, click the Close Filter button within the Filter Panel.

Disable/Enable the Filter

media_1450188157627.png

Click the Enable Filter button within the Filter Panel.