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();
})
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
