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. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

How to implement filtering for null / blank dates?

Thread ID:

Created:

Updated:

Platform:

Replies:

143500 Mar 22,2019 09:07 PM UTC Apr 24,2019 11:37 AM UTC ASP.NET MVC - EJ 2 6
loading
Tags: Grid
Richard Werning
Asked On March 22, 2019 09:07 PM UTC

Looking at the following demo, all of the orders have a date assigned to it.
     https://ej2.syncfusion.com/aspnetmvc/Grid/FilterMenu#/material

With the following demo grid:
@(Html.EJS().Grid<PersonVm>("PersonGrid")
          .DataSource(ds => { ds.Url(Url.Action("LoadRecords")).UpdateUrl(Url.Action("Edit")).InsertUrl(Url.Action("Create")).Adaptor("UrlAdaptor"); }) 
          .EditSettings(edit => { edit.AllowAdding(true).AllowEditing(true).ShowDeleteConfirmDialog(true).Mode(EditMode.Dialog); })
          .AllowFiltering().FilterSettings(filter => { filter.Type(FilterType.Menu); })
          .Columns(col => {
              col.Field(p => p.Id).IsPrimaryKey(true).IsIdentity(true).Type("number").Format("N0").Add();
              col.Field("Prefix").HeaderText("Prefix").Type("string").Add();
              col.Field("FirstName").HeaderText("First tName").Type("string").Add();
              col.Field("LastName").HeaderText("Last Name").Type("string").Add();
              col.Field("Suffix").HeaderText("Suffix").Add();
              col.Field("PhoneNumber").HeaderText("Phone Number").Type("string").ValueAccessor("formatPhoneNumber").Add();
              col.Field("Birthday").HeaderText("Birthday").Type("date").Format("yMd").Add();
          })
          .Render()
    )

the filter for "Birthday" shows up correctly as a dateedit. However in my demo it's a nullable field and a user may want to search for any records that don't have a date assigned yet. I'm sure there's a way to do it with a custom filter, but cannot seem to work it out. Any assistance you can provide would be appreciated.

Thank you,
Rich Werning

Thavasianand Sankaranarayanan [Syncfusion]
Replied On March 26, 2019 11:05 AM UTC

Hi Richard, 

Greetings from Syncfusion. 

We have validated the defect Grid menu filter does not filter the null date values properly you have initiated with us. Thank you for taking the time to report this issue and helping us improve our product. At Syncfusion, we are committed to fixing all validated defects (subject to technological feasibility and Product Development Life Cycle ) and the defect fix will be included in our April 10th, 2019 patch release. 
  
You can now track the current status of your request, review the proposed resolution timeline, and contact us for any further inquiries through this link.  
 

Note: The above mentioned feedback portal is under review and it will be visible once feedback reviewed.  

Until then we appreciate your patience. 

Regards, 
Thavasianand S. 


Richard Werning
Replied On March 26, 2019 12:45 PM UTC

Thank you for the response, looking forward to the update.  When I follow that link I get a 404 Page not found error.

Thavasianand Sankaranarayanan [Syncfusion]
Replied On March 27, 2019 09:15 AM UTC

Hi Richard, 

Thanks for your patience. 

Feedback portal got reviewed so now you can able to see the feedback portal page.  

Regards, 
Thavasianand S. 


Richard Werning
Replied On March 27, 2019 09:45 AM UTC

Still doesn't work, when i click your link above i get a 404 wiree

Thavasianand Sankaranarayanan [Syncfusion]
Replied On March 28, 2019 10:54 AM UTC

Hi Richard, 

The mentioned feedback portal will be visible when you are login to that page and also created feedback portal is a private one. So, please login into that page.  

Regards, 
Thavasianand S. 


Thavasianand Sankaranarayanan [Syncfusion]
Replied On April 24, 2019 11:37 AM UTC

Hi Richard, 
 
Thanks for your patience. 
We are glad to announce that our Essential JavaScript 2 patch release (17.1.40) has been rolled out successfully and in that release, we have added the fix for an issue “Grid menu filter does not filter the null date values properly”. 
 
Regards, 
Thavasianand S. 


CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

;