ASPxFilterControlBase.OperationVisibility Event

Enables you to hide/show the operations for filterable properties within the control.

Assembly: DevExpress.Web.v18.2.dll

Declaration

C#
VB.NET

public event FilterControlOperationVisibilityEventHandler OperationVisibility

Public Event OperationVisibility As FilterControlOperationVisibilityEventHandler

Event Data

The OperationVisibility event's data class is FilterControlOperationVisibilityEventArgs. The following properties provide information specific to this event:

Property	Description
Operation	Gets the comparison operator type.
PropertyInfo	Gets the filterable property of the filter expression.
Visible	Gets or sets a value specifying whether the filter operation is visible.

Remarks

The OperationVisibility event is raised for each comparison operator, and allows you to dynamically control its visibility.

The event parameter’s FilterControlOperationVisibilityEventArgs.PropertyInfo and the FilterControlOperationVisibilityEventArgs.Operation properties identify the filterable property (the column being filtered) and its operations. To specify the operator’s visibility, use the FilterControlOperationVisibilityEventArgs.Visible property.

Example

Starting with v2010 vol 1. it is possible to hide filter operation items (Contains, Equals, etc.). In the ASPxFilterControl.OperationVisibility event handler, a database field name is analyzed, and based on custom conditions, unnecessary operations are hidden.

Note

A complete sample project is available at https://github.com/DevExpress-Examples/how-to-hide-filter-operation-items-e2218

<%@ Page Language="C#" AutoEventWireup="true"  CodeFile="Default.aspx.cs" Inherits="_Default" %>
<%@ Register Assembly="DevExpress.Web.ASPxGridView.v10.1" Namespace="DevExpress.Web.ASPxGridView" TagPrefix="dx" %>
<%@ Register Assembly="DevExpress.Web.ASPxEditors.v10.1" Namespace="DevExpress.Web.ASPxEditors" TagPrefix="dx" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" runat="server">
    <title>Untitled Page</title>
</head>
<body>
    <form id="form1" runat="server">
        <table><tr><td>
            <table width="100%" cellpadding="0" cellspacing="0">
                <tr><td style="width:100px;">
                    <dx:ASPxFilterControl ID="filter" runat="server" ClientInstanceName="filter" OnOperationVisibility="filter_FilterOperationVisibility">
                        <Columns>
                            <dx:FilterControlSpinEditColumn PropertyName="CategoryID" />
                            <dx:FilterControlTextColumn PropertyName="CategoryName" />
                            <dx:FilterControlTextColumn PropertyName="Description" />
                        </Columns>
                        <ClientSideEvents Applied="function(s, e) { grid.ApplyFilter(e.filterExpression);}" />
                    </dx:ASPxFilterControl>
                    <table width="100%" cellpadding="0" cellspacing="5" style="margin-top: 8px">
                        <tr><td align="center">
                            <dx:ASPxButton runat="server" ID="btnApply" Text="Apply" AutoPostBack="false" UseSubmitBehavior="false">
                                <ClientSideEvents Click="function() { filter.Apply(); }" />
                            </dx:ASPxButton>
                        </td></tr>
                    </table>
                    </td><td>
                    </td><td>
                    <dx:ASPxGridView ID="grid" ClientInstanceName="grid" runat="server" DataSourceID="AccessDataSource1"
                        KeyFieldName="CategoryID" Width="100%" AutoGenerateColumns="False">
                        <Columns>
                            <dx:GridViewDataTextColumn FieldName="CategoryID" VisibleIndex="0" />
                            <dx:GridViewDataTextColumn FieldName="CategoryName" VisibleIndex="1" />
                            <dx:GridViewDataTextColumn FieldName="Description" VisibleIndex="2" />
                        </Columns>
                    </dx:ASPxGridView>
                </td></tr>
            </table>
        </td></tr></table>
        <asp:AccessDataSource ID="AccessDataSource1" runat="server" DataFile="~/App_Data/nwind.mdb"
            SelectCommand="SELECT * FROM [Categories]" />

    </form>
</body>
</html>

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Collections.Generic;
using DevExpress.Data.Filtering.Helpers;
using DevExpress.Web.ASPxEditors;


public partial class _Default : System.Web.UI.Page {
    static List<ClauseType> AllowedOperations {
        get {
            return new List<ClauseType>(new ClauseType[6]{ 
                    ClauseType.Equals, ClauseType.DoesNotEqual,
                    ClauseType.BeginsWith, ClauseType.EndsWith,
                    ClauseType.Contains, ClauseType.DoesNotContain
                });
        }
    }
    protected void Page_Load(object sender, EventArgs e) {
        if(!IsPostBack) {
            filter.FilterExpression = grid.FilterExpression = "[CategoryName] Like '%ns%'";
        }
    }
    protected void filter_FilterOperationVisibility(object sender, FilterControlOperationVisibilityEventArgs e) {
        if(e.PropertyInfo.PropertyName == "CategoryName" || e.PropertyInfo.PropertyName == "Description") {
            e.Visible = AllowedOperations.Contains(e.Operation);
        }
    }
}

Imports Microsoft.VisualBasic
Imports System
Imports System.Data
Imports System.Configuration
Imports System.Web
Imports System.Web.Security
Imports System.Web.UI
Imports System.Web.UI.WebControls
Imports System.Web.UI.WebControls.WebParts
Imports System.Web.UI.HtmlControls
Imports System.Collections.Generic
Imports DevExpress.Data.Filtering.Helpers
Imports DevExpress.Web.ASPxEditors


Partial Public Class _Default
    Inherits System.Web.UI.Page
    Private Shared ReadOnly Property AllowedTypes() As List(Of ClauseType)
        Get
            Return New List(Of ClauseType)(New ClauseType(5){ ClauseType.Equals, ClauseType.DoesNotEqual, ClauseType.BeginsWith, ClauseType.EndsWith, ClauseType.Contains, ClauseType.DoesNotContain })
        End Get
    End Property
    Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs)
        If (Not IsPostBack) Then
            grid.FilterExpression = "[CategoryName] Like '%ns%'"
            filter.FilterExpression = grid.FilterExpression
        End If
    End Sub
    Protected Sub filter_FilterOperationVisibility(ByVal sender As Object, ByVal e As FilterControlOperationVisibilityEventArgs)
        If e.PropertyInfo.PropertyName = "CategoryName" OrElse e.PropertyInfo.PropertyName = "Description" Then
            e.Visible = AllowedTypes.Contains(e.Operation)
        End If
    End Sub
End Class

<%@ Page Language="vb" AutoEventWireup="true"  CodeFile="Default.aspx.vb" Inherits="_Default" %>
<%@ Register Assembly="DevExpress.Web.ASPxGridView.v10.1" Namespace="DevExpress.Web.ASPxGridView" TagPrefix="dx" %>
<%@ Register Assembly="DevExpress.Web.ASPxEditors.v10.1" Namespace="DevExpress.Web.ASPxEditors" TagPrefix="dx" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" runat="server">
    <title>Untitled Page</title>
</head>
<body>
    <form id="form1" runat="server">
        <table><tr><td>
            <table width="100%" cellpadding="0" cellspacing="0">
                <tr><td style="width:100px;">
                    <dx:ASPxFilterControl ID="filter" runat="server" ClientInstanceName="filter" OnOperationVisibility="filter_FilterOperationVisibility">
                        <Columns>
                            <dx:FilterControlSpinEditColumn PropertyName="CategoryID" />
                            <dx:FilterControlTextColumn PropertyName="CategoryName" />
                            <dx:FilterControlTextColumn PropertyName="Description" />
                        </Columns>
                        <ClientSideEvents Applied="function(s, e) { grid.ApplyFilter(e.filterExpression);}" />
                    </dx:ASPxFilterControl>
                    <table width="100%" cellpadding="0" cellspacing="5" style="margin-top: 8px">
                        <tr><td align="center">
                            <dx:ASPxButton runat="server" ID="btnApply" Text="Apply" AutoPostBack="false" UseSubmitBehavior="false">
                                <ClientSideEvents Click="function() { filter.Apply(); }" />
                            </dx:ASPxButton>
                        </td></tr>
                    </table>
                    </td><td>
                    </td><td>
                    <dx:ASPxGridView ID="grid" ClientInstanceName="grid" runat="server" DataSourceID="AccessDataSource1"
                        KeyFieldName="CategoryID" Width="100%" AutoGenerateColumns="False">
                        <Columns>
                            <dx:GridViewDataTextColumn FieldName="CategoryID" VisibleIndex="0" />
                            <dx:GridViewDataTextColumn FieldName="CategoryName" VisibleIndex="1" />
                            <dx:GridViewDataTextColumn FieldName="Description" VisibleIndex="2" />
                        </Columns>
                    </dx:ASPxGridView>
                </td></tr>
            </table>
        </td></tr></table>
        <asp:AccessDataSource ID="AccessDataSource1" runat="server" DataFile="~/App_Data/nwind.mdb"
            SelectCommand="SELECT * FROM [Categories]" />

    </form>
</body>
</html>

Controls

Tools

Controls and Extensions

Tools

Maintenance Mode

Controls

Tools

Controls and Extensions

Tools

Maintenance Mode

ASPxFilterControlBase.OperationVisibility Event

Declaration

Event Data

Remarks

Example