Cannot filter with Operator=@Operator.Contains

[Peter Morris]

Filtering works nicely for StartsWith, but when I set the operator to Contains it still acts as if it were set to StartsWith

How can I fix this?

@page "/"

<h1>Hello, world!</h1>

<EjsGrid DataSource="@Orders" AllowFiltering="true" AllowPaging="true">
    <GridColumns>
        <GridColumn Field=@nameof(Order.OrderID) HeaderText="Order ID" TextAlign="TextAlign.Right" Width="120"></GridColumn>
        <GridColumn Field=@nameof(Order.CustomerID) HeaderText="Customer Name" Width="150"></GridColumn>
        <GridColumn Field=@nameof(Order.OrderDate) HeaderText="Order Date" Format="d" Type="ColumnType.Date" TextAlign="TextAlign.Right" Width="130"></GridColumn>
        <GridColumn Field=@nameof(Order.Freight) HeaderText="Freight" Format="C2" TextAlign="TextAlign.Right" Width="120"></GridColumn>
    </GridColumns>
    <GridFilterColumns>
        <GridFilterColumn Field=@nameof(Order.CustomerID) Operator=@Syncfusion.EJ2.Blazor.Operator.Contains/>
    </GridFilterColumns>
</EjsGrid>

@code{
    public List<Order> Orders { get; set; }

    protected override void OnInitialized()
    {
        Orders = Enumerable.Range(1, 75).Select(x => new Order()
        {
            OrderID = 1000 + x,
            CustomerID = (new string[] { "ALFKI", "ANANTR", "ANTON", "BLONP", "BOLID" })[new Random().Next(5)],
            Freight = 2.1 * x,
            OrderDate = (new DateTime[] { new DateTime(2010, 5, 1), new DateTime(2010, 5, 2), new DateTime(2010, 5, 3), })[new Random().Next(3)],
        }).ToList();
    }

    public class Order
    {
        public int? OrderID { get; set; }
        public string CustomerID { get; set; }
        public DateTime? OrderDate { get; set; }
        public double? Freight { get; set; }
    }
}

[Madhu Sudhanan P]

Hi Peter, 

 

Greetings from Syncfusion support.  

 

To change the default filter operator for particular column (CustomerID) in Grid. We suggest you to define the filter operator at column level using Filter property. Refer the below code example.  

 

 

<EjsGrid DataSource="@Orders" AllowFiltering="true" AllowPaging="true" Height="315"> 

    <GridColumns> 

        <GridColumn Field=@nameof(Order.OrderID) HeaderText="Order ID" TextAlign="TextAlign.Center" Width="120"></GridColumn> 

        <GridColumn Field=@nameof(Order.CustomerID) HeaderText="Customer Name"  Filter="@FilterParams" TextAlign="TextAlign.Center" Width="150"></GridColumn> 

        <GridColumn Field=@nameof(Order.OrderDate) HeaderText=" Order Date" Format="d" Type="ColumnType.Date" TextAlign="TextAlign.Center" Width="130"></GridColumn> 

        <GridColumn Field=@nameof(Order.Freight) HeaderText="Freight" Format="C2" TextAlign="TextAlign.Center" Width="120"></GridColumn> 

    </GridColumns> 

</EjsGrid> 

 

@code{ 

    object FilterParams = new { @@operator = "contains" }; 

    . . .  . .   

} 

 

 

Note: GridFilterSettings is used to set default filtered columns or initial filtering to the Grid. If you want to change the default operator kindly refer the above solution. 

 

Kindly refer our UG documentation for your reference. 

 

https://ej2.syncfusion.com/blazor/documentation/grid/filtering/?no-cache=1#change-default-filter-operator  

 

Please get back to us if you have further queries.      

 

Regards, 

Madhu Sudhanan P