We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date
  1. Home
  2. Forum
  3. ASP.NET Core
  4. Excel filter in Date column

Excel filter in Date column

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

18 Replies
TS Thavasianand Sankaranarayanan Syncfusion Team November 13, 2018 01:03 PM UTC

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. 

 


 


Please get back to us if you need further assistance. 
 
Regards, 
Thavasianand S. 


CO Costa November 15, 2018 01:37 AM UTC

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



CO Costa November 15, 2018 04:58 AM UTC

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

CO Costa November 15, 2018 09:22 AM UTC

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.

CO Costa November 15, 2018 10:24 AM UTC

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

TS Thavasianand Sankaranarayanan Syncfusion Team November 15, 2018 11:55 AM UTC

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. 


CO Costa November 30, 2018 08:52 AM UTC

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

TS Thavasianand Sankaranarayanan Syncfusion Team December 3, 2018 06:27 AM UTC

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. 


CO Costa December 3, 2018 12:04 PM UTC

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.



CO Costa December 3, 2018 12:05 PM UTC


CO Costa December 3, 2018 12:06 PM UTC