Hi,
I am currently following the advice in this thread http://www.telerik.com/forums/using-datetimeoffset-in-column-filter in order to display datetimeoffset data in a grid. My questions are:
1) Are there plans to implement native support for the datetimeoffset type? It is a useful type for uniquely identifying a point in time above what datetime offers, so would be a useful type to support. The current solution seems a bit of a hack and native support would be much better.
2) Do I need to add any additional code to support columns sorting of datetimeoffsets as well as filtering? At present I am converting the datetimeoffsets to datetimes in my viewmodel to get around this issue.
My current code is as follows. The MapFilters function is as in the previous post. Should I be implementing a MapSorts function too? If so what would this look like?
Regards,
Michael
I am currently following the advice in this thread http://www.telerik.com/forums/using-datetimeoffset-in-column-filter in order to display datetimeoffset data in a grid. My questions are:
1) Are there plans to implement native support for the datetimeoffset type? It is a useful type for uniquely identifying a point in time above what datetime offers, so would be a useful type to support. The current solution seems a bit of a hack and native support would be much better.
2) Do I need to add any additional code to support columns sorting of datetimeoffsets as well as filtering? At present I am converting the datetimeoffsets to datetimes in my viewmodel to get around this issue.
My current code is as follows. The MapFilters function is as in the previous post. Should I be implementing a MapSorts function too? If so what would this look like?
Regards,
Michael
public
ActionResult LogEntries_Read([DataSourceRequest] DataSourceRequest request)
{
try
{
using
(var db =
new
SysLogContext())
{
// convert datetimeoffsets to datetimes in the filters and sorts since Kendo does not support datetimeoffset
if
(request.Filters.Any())
{
request.Filters.MapFilters(descriptor =>
{
if
(descriptor.Member ==
"Date"
)
{
descriptor.Value =
new
DateTimeOffset((DateTime) descriptor.Value);
}
});
}