Skip to main content
All docs
V25.1
  • ColumnViewOptionsFilter.FilterEditorAllowCustomExpressions Property

    Gets or sets whether the Filter Editor allows you to display, create, and edit custom expressions that cannot be converted to Filter Editor nodes.

    Namespace: DevExpress.XtraGrid.Views.Base

    Assembly: DevExpress.XtraGrid.v25.1.dll

    NuGet Packages: DevExpress.Win.Grid, DevExpress.Win.Navigation

    Declaration

    [DefaultValue(DefaultBoolean.Default)]
    [XtraSerializableProperty]
    public DefaultBoolean FilterEditorAllowCustomExpressions { get; set; }

    Property Value

    Type Default Description
    DefaultBoolean Default

    A value that specifies whether the Filter Editor allows you to display, create, and edit custom expressions.

    Available values:

    Name Description Return Value
    True

    The value is true.

    0

    False

    The value is false.

    1

    Default

    The value is specified by a global option or a higher-level object.

    2

    Property Paths

    You can access this nested property as listed below:

    Object Type Path to FilterEditorAllowCustomExpressions
    ColumnView
    .OptionsFilter .FilterEditorAllowCustomExpressions

    Remarks

    Individual filter expressions (for example, expressions that contain advanced or custom functions) cannot be converted to Filter Editor nodes. Below is an example:

    [Sales Date] > AddDays(LocalDateTimeToday(), -25)

    The AllowCustomExpressions property specifies whether and how the Filter Editor displays these expressions. The following options are available:

    True

    The Filter Editor displays custom expressions, and allows users to edit existing and create new custom expressions.

    FilterControl-Custom Expressions

    Users can create new custom expressions from a context menu.

    FilterControl - Add Custom Expressions menu

    Users can click the expression to open the Expression Editor, which allows them to edit the expression.

    FilterControl-Custom Expressions-Expression Editor

    Handle the ColumnView.FilterExpressionEditorCreated event to customize this Expression Editor.

    Default
    The Filter Editor displays custom expressions as simple text. A user cannot edit or create custom expressions. FilterControl-Custom Expressions-Default mode
    False
    The Filter Editor does not display custom expressions, and does not allow users to create new ones.

    Conditional Formatting

    The FilterEditorAllowCustomExpressions property also specifies whether a user can use the Expression Editor to create custom conditional formatting expressions. See the following help topic for more information: Show Conditional Formatting in Grid Menu.

    See Also