End-User Capabilities: Filtering

  • 2 minutes to read

Create a Simple Filter Condition

To select records that contain a specific value in a specific column/card field, do the following.

  1. Invoke the filter dropdown list containing available filter values. See below on how to do this.

    By default, if filtering is applied, the filter dropdown will only display the values that match the current filter criteria. If the SHIFT key is pressed while opening the filter dropdown, all values will be listed (not only those that match the current filter criteria).

  2. Select the required filter value in the filter dropdown list.

    EU_XtraGrid_GridView_ColumnFilterDropdownList

    The filter dropdown list will be immediately closed, and the control will display the records that contain the specified value in the specified column/card field.

    If the filter dropdown list provides check boxes to the left of filter values, multiple values can be selected (checked) simultaneously.

    EU_XtraGrid_GridView_CheckedFilterDropdownList

    In this mode, click Ok to close the filter dropdown list and apply the filter.

You can sequentially filter data against multiple columns using the method described above.

Create Complex Filter Criteria

To construct filter criteria involving multiple columns/card fields, and using various comparison operators, do one of the following.

  • Invoke the filter dropdown list (see below) and click Custom. This will invoke the Custom Filter Dialog, allowing you to compare a column with one or two values:

    EU_XtraGrid_CustomFilterDialog

  • Use the Filter Builder that allows complex filter criteria to be constructed. See End-User Capabilities: Filter Editor to learn more.

Clear the Filter

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

  • Invoke the filter dropdown list (see below) and click (All).
  • In Grid Views, right-click the column header and select Clear Filter.

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

EU_XtraGrid_FilterPanel_CloseFilterButton

Disable/Enable the Filter

Click the Enable Filter button within the Filter Panel.

EU_XtraGrid_FilterPanel_EnableFilterButton

Invoke the Filter Dropdown List

  • In Grid Views, hover over the column header. Click the filter button (EU_XtraGrid_GridView_ColumnFilterButton_Icon) within the column header that appears.

    EU_XtraGrid_GridView_ColumnFilterButton

  • In Card Views, click the Customize button and then click the Filter button corresponding to the target column.

    EU_GridControl_CardView_CustomizationMenuFilterButton

  • In Layout Views, hover over the target card field within any card. Click the filter button (EU_XtraGrid_LayoutView_FilterButton_Icon) that appears.

    EU_XtraGrid_LayoutView_FilterSortButtons

See Also