Menu filter and excel filter in one grid

[Pawel Klimczyk]

Is it possible to have both "menu filter" and "excel filter" in one grid?
For example "menu filter" for Column A and "excel filter" for Column B.

[Mani Sankar Durai]

Hi Pawel, 

Thanks for contacting Syncfusion support, 

Yes, we can enable both excel and menu filter for different columns. We can achieve it by using the FilterType property of columns as either menu or excel for the particular column.  

For your convenience please refer the below code example, 

… 

$("#Grid").ejGrid({ 

                    … 

                    allowFiltering: true, 

                    filterSettings: { filterType: "excel" }, 

                    columns: [ 

                            { field: "OrderID", isPrimaryKey: true, headerText: "Order ID", textAlign: ej.TextAlign.Right, width: 75 }, 

                            { field: "CustomerID", filterType: "menu", headerText: "Customer ID", width: 120 }, 

                    ]  

                }); 

                }); 

We have also prepared a sample that can be downloaded from the below link, 

 

Link: http://jsplayground.syncfusion.com/xtac3qd4 

Please let us know if you need further assistance. 

Regards, 

Manisankar Durai. 

[Vishal Manghnani]

Hi Could you post a sample for doing this without javascript?

I tried it by setting the grid property .AllowFiltering() and then set FilterType property of a column as col.Field(p => p.ClientName).HeaderText("Client Name").FilterType(FilterOption.Excel).Add(); 

The column client name still showed as a Text box rather than an excel type drop down

Thanks

[Mani Sankar Durai]

Hi Pawel, 

 

We have analyzed your query and found the cause of the issue. You have initialized the filterType as excel for one column and not initialized the filterSettings to have the filterType as menu for other columns. This is the cause of the issue. If you enable the filterType as filterBar which is common for all columns and set the filterType as excel or menu for particular columns it will show as filterBar (Textbox). So we suggest you to mention the filterSettings to render the filterType as either menu or excel for other columns. 

Please refer the below code example, 

[Index.cshtml] 

@(Html.EJ().Grid<object>("Grid") 

         … 

        .AllowFiltering() 

        .FilterSettings(filter => { filter.FilterType(FilterType.Menu); }) 

        .Columns(col => 

        { 

            

col.Field("Freight").HeaderText("Client Name").FilterType(FilterOption.Excel).Add();  

        }) 

) 

We have also prepared a sample that can be downloaded from the below link, 

Link: http://www.syncfusion.com/downloads/support/forum/124991/ze/Sample313746692 

Please let us know if you need further assistance 

Regards, 

Manisankar Durai 

[Clovis]

Hi

Is it possible to have FilterBar as grid filtering option and Excel or Menu for specific columns ?

Thanks

[Balasubramanian Masilamani]

Hi Clovis, 

Thanks for contacting Syncfusion support. 

We have checked your query and found that you want to use filterBar as grid filterType and with Menu or Excel filter as filterType for specific columns. Since it is not feasible by setting the menu or excel as column filterType when the grid contains the filterType as filterBar . If you need to use either Menu filter or excel filter for specific columns, we suggest you to use Menu filter or Excel filter as grid filterType. 

 

Please let us know if you need further assistance. 

 

 

Regards, 

Balasubramanian Masilamani