Excel filter no working with null values

[Manuel Caballero]

Hello.

The Excel filter of one column doesn't work (it doesn't appear when you click on it) if there are any null value. For example, when the type is DateTime? and there are some rows with null values.

Thanks.

[Farveen Sulthana Thameeztheen Basha]

Hi Manuel, 

Greetings from Syncfusion Support. 

Query#:- The Excel filter of one column doesn't work (it doesn't appear when you click on it) if there are any null value. For example, when the type is DateTime?  

 

We have prepared sample using Excel Filter with DateTime column by setting Type property as datetime(with null values in it) but we are unable to replicate the problem at our end.  

Sample Link:- https://www.syncfusion.com/downloads/support/forum/168578/ze/Sample142103_(5)-122579306 

Code below:- 

@(Html.EJ().Grid<OrdersView>("FlatGrid") 

        .Datasource((IEnumerable<object>)ViewBag.dataSource) 

        .AllowSorting() 

        .AllowPaging() 

            .AllowFiltering() 

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

            .Columns(col => 

            { 

                .   .   . 

               col.Field("OrderDate").HeaderText("Order Date").TextAlign(TextAlign.Right).Type("datetime").Priority(4).EditType(EditingType.DateTimePicker).Format("{0:MM/dd/yyyy hh:mm:ss}").Add(); 

                 

            })) 

 

Note:- We suspect that issue will occur when we bind empty dataSource for the first row of the Grid. When you bind the empty dataSource or null values Grid cannot find the actual data type of a column. In this case, you have to set the data type of the column explicitly to perform the Editing/Filtering and other Grid operations. Please ensure to add Type property for that column. 

https://help.syncfusion.com/aspnetmvc/grid/columns#type 

 

If you are facing issue different from above mentioned share us the following details to find the cause of the issue.. 

1. Complete Grid code example.
2. Share Video Demo or Screenshot of Script Error(if any occurs) on console window.
3. If possible replicate the issue in the above sample and revert us back.
4. Have you faced the issue on Clicking the Excel Filter Dialog.

Regards, 

Farveen sulthana T 

 

[Manuel Caballero]

Hello,

I have configured the column with  Type("datetime") and the filter works!!!

Thank you!!!

[Pon Selva Jeganathan]

Hi Manuel,  

   

Thanks for the update . 

 

We are glad to hear your query has been solved. 

 

Kindly get back to us for further assistance. We are happy to assist you. 

Regards, 

Pon selva