ColumnBase.FilterPopupGroupFields Property

Gets or sets names of the fields by which filter values are grouped in the column’s drop-down filter. These names should be separated by comma, semicolon, or space. The order of field names determines the hierarchy in the group.

Namespace: DevExpress.Xpf.Grid

Assembly: DevExpress.Xpf.Grid.v19.1.Core.dll

Declaration

C#

public string FilterPopupGroupFields { get; set; }

VB.NET

Public Property FilterPopupGroupFields As String

Property Value

Type	Description
String	Names of the fields by which filter values are grouped in the column’s drop-down filter.

Remarks

Tip

Demos:

• Excel Style Filtering
• Excel-Style Drop-Down Filter - Group Filters

Requires installation of WPF Subscription. Download

You can group filter values in the Excel-style Drop-down Filter to allow users to filter data by multiple columns. Set the FilterPopupGroupFields property to names of the fields by which filter values should be grouped. Separate names by comma, semicolon, or space. The order of field names determines the hierarchy in the group.

Note

You can use the FilterPopupGroupFields property only in the Excel-style Drop-down Filter that works in Smart mode (the ColumnBase.FilterPopupMode property is set to FilterPopupMode.ExcelSmart or the DataViewBase.ColumnFilterPopupMode property is set to ColumnFilterPopupMode.ExcelSmart).

Example 1

The code sample below shows how to display the available models below each trademark in the Trademark column’s drop-down filter:

Xaml

<dxg:GridControl>
  <dxg:GridControl.Columns>
    <dxg:GridColumn FieldName="ID" />
    <dxg:GridColumn FieldName="Model"/>
    <dxg:GridColumn FieldName="Trademark" FilterPopupGroupFields="Trademark;Model" />
  </dxg:GridControl.Columns>
  <!-- ... -->
</dxg:GridControl>

The customized column’s values are displayed at the root level by default; you can omit its name (“Trademark”). The code sample below has the same effect:

Xaml

<dxg:GridControl>
  <dxg:GridControl.Columns>
    <dxg:GridColumn FieldName="ID" />
    <dxg:GridColumn FieldName="Model"/>
    <dxg:GridColumn FieldName="Trademark" FilterPopupGroupFields="Model" />
  </dxg:GridControl.Columns>
  <!-- ... -->
</dxg:GridControl>

Example 2

The code sample below shows how to display the available models below each trademark in the Model column’s drop-down filter:

Xaml

<dxg:GridControl>
  <dxg:GridControl.Columns>
    <dxg:GridColumn FieldName="ID" />
    <dxg:GridColumn FieldName="Trademark" />
    <dxg:GridColumn FieldName="Model" FilterPopupGroupFields="Trademark;Model" />
  </dxg:GridControl.Columns>
  <!-- ... -->
</dxg:GridControl>

The customized column’s values are not displayed at the root level in this case, its name (“Model”) cannot be omitted.