Excel filter in Date column

[Costa]

Hi. I have created the application Razor Pages Syncfusion EJ2 with grid an URL-adapter and an excel filter (see attached file). Why doesn't the filter in the Release Date column work as expected?

Thanks.

Attachment: RazorPagesGridExcelFilter_28c7f04f.zip

[Thavasianand Sankaranarayanan]

Hi Costa, 

 

We have checked your query and tried to reproduce the issue at our end but it is unsuccessful. Please refer the below screenshot and sample link. 

 

 

Sample : http://www.syncfusion.com/downloads/support/directtrac/general/ze/excelfilter-orderdate-419472279  

Please get back to us if you need further assistance. 

 

Regards, 

Thavasianand S. 

[Costa]

Hi. Your sample with 2 selected items in filter. No record to display.

[Costa]

Also, all the same, please look at your project, with the addition of the ExcelFilter page (attached file). The behavior of the excel filter is slightly different.

Attachment: excelfilterorderdate_20d7d892.zip

[Costa]

Also, please tell us, which NuGet Package should be used for Razor Pages App's: Syncfusion.EJ2 or Syncfusion.EJ2.AspNet.Core? They have the same descriptions.

[Costa]

As I understand, the problem of filtering occurs exactly when using UrlAdaptor.

[Thavasianand Sankaranarayanan]

Hi Costa, 

 

We have checked your query and we have logged “Unable to filter the date column with excel filter using DataOperations class” as a bug. The fix for the issue will be available on November 28, 2018 patch release. Until then we appreciate your patience. 

 

Regards, 

Thavasianand S. 

[Costa]

Hi, November 28th has already passed. How's the work progressing?

[Thavasianand Sankaranarayanan]

Hi Costa,  

 

Sorry for inconvenience caused. 

 

In our last patch release will be postponed due to the Essential Studio Volume 4, 2018  Beta release. However we will include the fix “Unable to filter the date column with excel filter using DataOperations class” in our upcoming Volume 4, 2018 beta release at the mid of the December. 

 

Regards, 

Thavasianand S. 

[Costa]

Hi, Thavasianand Sankaranarayanan.

Thanks for update.

I would also like to draw your attention that if there are null fields, Excel filter does not allow you to filter the data with null values.

[Costa]

[Costa]

[Dhivya Rajendran]

Hi Costa, 

Query : I would also like to draw your attention that if there are null fields, Excel filter does not allow you to filter the data with null values. 

 

We have validated the provided information and you can achieve your requirement by using the below way. In the below sample, we have used empty string instead of null values to filter the blanks record in excel filtering.  

Please find the below example code, attached snapshot and sample link for your reference. 

[Index.cshtml.cs] 

public static List<OrdersDetails> GetAllRecords() 

            { 

                if (order.Count() == 0) 

                { 

                    . . . .  

                    { 

                        order.Add(new OrdersDetails(code + 1, "ALFKI", i + 0, 2.3 * i, false, new DateTime(1991, 05, 15), "Berlin", "Simons bistro", "Denmark", new DateTime(1996, 7, 16), "Kirchgasse 6")); 

                        order.Add(new OrdersDetails(code + 2, "ANATR", i + 2, 3.3 * i, true, new DateTime(1990, 04, 04), "", "Queen Cozinha", "Brazil", new DateTime(1996, 9, 11), "Avda. Azteca 123")); 

                        order.Add(new OrdersDetails(code + 5, "BOLID", i + 4, 6.3 * i, true, new DateTime(1953, 02, 18), "", "Hanari Carnes", "Switzerland", new DateTime(1997, 12, 3), "1029 - 12th Ave. S.")); 

          . . . . . . 

           } 

 

Sample : http://www.syncfusion.com/downloads/support/directtrac/general/ze/excelfilter-blanks-294056286  

Regards, 

R.Dhivya 

[Costa]

Thanks. A variant with empty strings, I found myself. But it requires additional coding in real Apps. I hope this is a temporary workaround?

[Madhu Sudhanan P]

Hi Costa, 

Thanks for the update. We have analyzed and confirmed “Null values are not displaying as blanks in checkbox filter” as bug and this fix will be available in any of the upcoming releases. 

Regards, 

Madhu Sudhanan P 

[Costa]

Hi Costa,  

 

Sorry for inconvenience caused. 

 

In our last patch release will be postponed due to the Essential Studio Volume 4, 2018  Beta release. However we will include the fix “Unable to filter the date column with excel filter using DataOperations class” in our upcoming Volume 4, 2018 beta release at the mid of the December. 

 

Regards, 

Thavasianand S. 

Version 16.4.0.40 (Vol 4 2018 - Dec 10, 2018) Beta has same error.

[Thavasianand Sankaranarayanan]

Hi Costa, 

Sorry for the inconvenience caused. 

We have included the fix for the issue “Unable to filter the date column with excel filter using DataOperations class” in our Volume 4, 2018 release(not included in Beta). We glad to announce that our Volume 4, 2018 release has been rolled out successfully. We suggest you to use the latest version (16.4.0.42) to resolve the reported problem. 

Regards, 

Thavasianand S. 

[Eduardo]

The same problem “Unable to filter the date column with excel filter using DataOperations class

on ASP.NET Core EJ1

Version: 16.4.0.47

Attachment: syncfusionversion_e1676135.zip

[Vignesh Natarajan]

Hi Costa, 

 

Query : Unable to filter the date column with excel filter using DataOperations class in EJ1 Core 

 

We are able to reproduce the mentioned issue on our side also. This issue occurs by default on ASP.Net core sample due to variance in Timezone. To avoid this issue, we suggest you to parse dates while serializing. Modify your  startup.cs page as given in the below code example.  

 

public void ConfigureServices(IServiceCollection services)  

        {  

            // Add framework services.  

            services.AddMvc().AddXmlSerializerFormatters()  

            .AddJsonOptions(x =>  

             {  

                 x.SerializerSettings.DateParseHandling = Newtonsoft.Json.DateParseHandling.None; 
                x.SerializerSettings.ContractResolver = null;              

     });  

            services.AddCors(options => options.AddPolicy("AllowAll", p => p.AllowAnyOrigin().AllowAnyHeader().AllowAnyMethod()));  

        }  

 

 

If above solution does not resolve your query, please get back to us with more details regarding your query.  

 

Regards,  

Vignesh Natarajan