I am trying to filter a Kendo grid DateTime column but it is not returning any results because it takes into account the time part as well. Is there a way I can filter a column without it using the timepart. Is it possible to filter the column by dd/MM/yyyy instead of dd/MM/yyyy hh:mm:ss
Below is my grid code
View
@(Html.Kendo().Grid<PaperworkViewRecord>()
.Name("IncompleteStartersPaperworkGrid")
.Sortable()
.Pageable(paging => paging.PageSizes(new int[]{10,25,50,100,200}).Numeric(true).Numeric(true).PreviousNext(true))
.Filterable()
.Groupable()
.ColumnMenu()
.Columns(columns =>
{
columns.Bound(o => o.FirstName).Title("First Name");
columns.Bound(o => o.LastName).Title("Surname");
columns.Bound(o => o.BirthDate).Format("{0:dd/MM/yyyy}").Title("Birth date");
columns.Bound(o => o.StartDate).Format("{0:dd/MM/yyyy}").Title("Start Date").Template(o =>DateExtensions.FormatDate(o.StartDate));
columns.Bound(o => o.FrameworkName).Title("Framework");
columns.Bound(o => o.FundingStreamName).Title("Funding Stream");
columns.Bound(o => o.Assessor).Title("Assessor");
columns.Bound(o => o.ProviderName).Title("Provider").Hidden(true);
columns.Bound(o => o.IsFunded).Title("Funded").Hidden(true);
columns.Bound(o => o.AgeAtSignUp).Title("Signup Age").Hidden(true);
})
.EnableCustomBinding(true)
.DataSource(dataSource =>dataSource.Ajax()
.Read( read=>read.Action("GetIncompleteStartersModel_Read", "Compliance"))
.ServerOperation(true))
.Events(e=>e.DataBound("onIncompleteStartersPaperworkGridDataBound"))
)
DataSourceResult method
public DataSourceResult GetIncompleteSignupStarterPaperworkRecords(DataSourceRequest request)
{
var paperworkRecords = _paperworkRepository.FetchByType(PaperworkType.Starter.ToString())
.Where(x => !x.SignupComplete);
var paperworkDtoRecords = paperworkRecords.ToDataSourceResult(request, m => m.MapToPaperworkViewRecord());
return paperworkDtoRecords;
}
Below is my grid code
View
@(Html.Kendo().Grid<PaperworkViewRecord>()
.Name("IncompleteStartersPaperworkGrid")
.Sortable()
.Pageable(paging => paging.PageSizes(new int[]{10,25,50,100,200}).Numeric(true).Numeric(true).PreviousNext(true))
.Filterable()
.Groupable()
.ColumnMenu()
.Columns(columns =>
{
columns.Bound(o => o.FirstName).Title("First Name");
columns.Bound(o => o.LastName).Title("Surname");
columns.Bound(o => o.BirthDate).Format("{0:dd/MM/yyyy}").Title("Birth date");
columns.Bound(o => o.StartDate).Format("{0:dd/MM/yyyy}").Title("Start Date").Template(o =>DateExtensions.FormatDate(o.StartDate));
columns.Bound(o => o.FrameworkName).Title("Framework");
columns.Bound(o => o.FundingStreamName).Title("Funding Stream");
columns.Bound(o => o.Assessor).Title("Assessor");
columns.Bound(o => o.ProviderName).Title("Provider").Hidden(true);
columns.Bound(o => o.IsFunded).Title("Funded").Hidden(true);
columns.Bound(o => o.AgeAtSignUp).Title("Signup Age").Hidden(true);
})
.EnableCustomBinding(true)
.DataSource(dataSource =>dataSource.Ajax()
.Read( read=>read.Action("GetIncompleteStartersModel_Read", "Compliance"))
.ServerOperation(true))
.Events(e=>e.DataBound("onIncompleteStartersPaperworkGridDataBound"))
)
DataSourceResult method
public DataSourceResult GetIncompleteSignupStarterPaperworkRecords(DataSourceRequest request)
{
var paperworkRecords = _paperworkRepository.FetchByType(PaperworkType.Starter.ToString())
.Where(x => !x.SignupComplete);
var paperworkDtoRecords = paperworkRecords.ToDataSourceResult(request, m => m.MapToPaperworkViewRecord());
return paperworkDtoRecords;
}