Disable filtering on one column in Grid

[Junaid]

Good day,

I have five columns in Grid. I am filtering the columns using an API, but I want to disable filtration on one of the columns in the grid. Like there should be no filtration textbox showing for this column in the Grid.

How can I do that?

Thanks.

[Vignesh Natarajan]

Hi Junaid,  

Thanks for contacting Syncfusion forums.  

Query: “I want to disable filtration on one of the columns in the grid” 

 

We can disable filtering for particular column using AllowFiltering property of GridColumn. Refer the below code example.  

<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) AllowFiltering="false" HeaderText=" Order Date" Format="yMd" 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> 

</EjsGrid> 

Also refer our UG documentation for your reference 

https://ej2.syncfusion.com/blazor/documentation/grid/columns/#controlling-grid-actions 

https://help.syncfusion.com/cr/blazor/Syncfusion.Blazor.Grids.GridColumn.html#Syncfusion_Blazor_Grids_GridColumn_AllowFiltering  

Query: “Like there should be no filtration textbox showing for this column in the Grid.” 

By default when we disable filtering for particular column, its filter bar (input box) will be disabled. You can achieve this requirement using these methods 1. By changing the FilterType or 2. Using FilterbarTemplate.  

 

1. Using FilterBarTemplate.

You can define the empty FilterTemplate for that particular column, if you want to remove the default filter bar. Refer the below code example.  

<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) AllowFiltering="false" HeaderText=" Order Date" Format="yMd" Type="ColumnType.Date" TextAlign="TextAlign.Right" Width="130"> 

            <FilterTemplate></FilterTemplate> 

        </GridColumn> 

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

    </GridColumns> 

</EjsGrid> 

Also refer our UG documentation for your reference 

https://ej2.syncfusion.com/blazor/documentation/grid/filtering/#filter-bar-template-with-custom-component   

2. By Changing the Filter type as Excel / Menu.

Refer our UG documentation for your reference 

https://ej2.syncfusion.com/blazor/documentation/grid/filtering/#filter-menu   

https://ej2.syncfusion.com/blazor/documentation/grid/filtering/#excel-like-filter  

Please get back to us if you have further queries.  

Regards, 

Vignesh Natarajan. 

[Junaid]

Thanks. That helped!!

Regards

Junaid

[Vignesh Natarajan]

Hi Junaid,  

Thanks for the update.  

We are glad to hear that your query has been resolved by our solution. 

Please get back to us if you have further queries. 

Regards, 

Vignesh Natarajan.