Using DateTimeOffset in column filter

[Aleksey 311]

Hi!

When I try to filter a column of type DateTimeOffset, I get an error like: "System.InvalidCastException: Invalid cast "System.DateTime" to quot;System.DateTimeOffset"."

Please tell me how to solve this problem. Thank you!

[Daniel]

Hello,

This is not currently supported. The DataSourceRequest will always create a DateTime and not a DateTimeOffset. You should use a DateTime property in order to avoid the exception. If this is not possible in your scenario then I can suggest to convert the filter value to DateTimeOffset in the request filters e.g.

public static class Extensions
{
    public static void MapFilters(this IList<IFilterDescriptor> filters, Action<FilterDescriptor> action)
    {
        foreach (var filter in filters)
        {
            if (filter is CompositeFilterDescriptor)
            {
                MapFilters(((CompositeFilterDescriptor)filter).FilterDescriptors, action);
            }
            else
            {
                action((FilterDescriptor)filter);
            }
        }
    }
}

if (request.Filters.Any())
{
    request.Filters.MapFilters(descriptor =>
        {
            if (descriptor.Member == "MyField")
            {
                descriptor.Value = new DateTimeOffset((DateTime)descriptor.Value);
            }
        });
}

Regards,
Daniel
Telerik

 

 

[Aleksey 311]

Thank you! Its working for me.