WinColumnsListEditor.LookupColumnFilterMode Property

Specifies how the Automatic Filtering Row is displayed and how Find Panel performs a search in Server mode (see CollectionSourceBase.DataAccessMode) for lookup columns.

Namespace: DevExpress.ExpressApp.Win.Editors

Assembly: DevExpress.ExpressApp.Win.v23.2.dll

NuGet Packages: DevExpress.ExpressApp.Win, DevExpress.ExpressApp.Win.Design

NuGet Package: DevExpress.ExpressApp.Win

Declaration

C#

public ColumnFilterMode LookupColumnFilterMode { get; set; }

VB.NET

Public Property LookupColumnFilterMode As ColumnFilterMode

Property Value

Type	Description
ColumnFilterMode	A ColumnFilterMode enumeration value specifying how the Find Panel performs searching in server mode.

Available values:

Name	Description
Value	A column’s data is filtered by the edit values.
DisplayText	A column’s data is filtered by the display text.

Remarks

The following table demonstrates how the Automatic Filtering Row and Find Panel behavior changes depending on the LookupColumnFilterMode value in lookup columns.

LookupColumnFilterMode Value	Auto Filter Row Behavior	Find Panel Behavior
ColumnFilterMode.Value	The Auto Filter Row cells are displayed using lookup editors.	The Find Panel searches over key property values of objects displayed by the WinColumnsListEditor in Server mode.
ColumnFilterMode.DisplayText	The Auto Filter Row is displayed using text boxes.	The Find Panel searches over the display text of the visible columns.

You can use the following Controller to access this property.

C#

using DevExpress.ExpressApp;
using DevExpress.ExpressApp.Win.Editors;
// ...
public class LookupColumnFilterModeController : ViewController<ListView> {
    protected override void OnActivated() {
        base.OnActivated();
        GridListEditor gridListEditor = View.Editor as GridListEditor;
        if (gridListEditor != null) {
            gridListEditor.LookupColumnFilterMode = DevExpress.XtraGrid.ColumnFilterMode.DisplayText;
        }
    }
}

VB.NET

Imports DevExpress.ExpressApp
Imports DevExpress.ExpressApp.Win.Editors
' ...
Public Class LookupColumnFilterModeController
    Inherits ViewController(Of ListView)
    Protected Overrides Sub OnActivated()
        MyBase.OnActivated()
        Dim gridListEditor As GridListEditor = TryCast(View.Editor, GridListEditor)
        If gridListEditor IsNot Nothing Then
            gridListEditor.LookupColumnFilterMode = DevExpress.XtraGrid.ColumnFilterMode.DisplayText
        End If
    End Sub
End Class

To change the behavior for a specific column only, use the GridColumn.FilterMode property. To access this property, use the approach demonstrated in the following article How to: Access the Grid Component in a List View.