How to sort using hours, minutes, seconds?

[Raymond]

Hi

I have in my object couple columns of type DateTime.  I use built in functionality for sorting. On the column header user can type date. My problem is that I can define only date, hours, minutes and seconds are always zero (take a look at the screenshot).

Is there any possibility to let the user define also hours?

 

Regards

[Martin Vasilev]

Hello Raymond,

Thank you for writing.

I suppose that actually you mean "filtering" rather than "sorting"? In this case, RadGridView does not support the required functionality out of the box. However, you can take a look at the custom filtering, which will allow you to customize the filter functionality according to your needs.

Let me know if you have any additional questions.

All the best,
Martin Vasilev
the Telerik team

[Raymond]

Yes I have problem with filtering - sorry my mistake.

I cannot use custom filtering because user even cannot type hours, minutes and seconds if column type is DateTime.

I would have to change data type to string and then use custom filtering.

[Martin Vasilev]

Hello Raymond,

Thank you for getting back to me.

It seems that the implementation of your requirement using the standard filtering functionality is not possible. Although the default filtering editor can be changed for a specific cell, the filtering cannot be customized to accept different than the expected data format. Moreover, by default we are using a customized DateFilterExpression, which deliberately eliminates the time part since that was the most popular functionality that our customers asked for.

Nevertheless, we will consider improving our built-in filtering capabilities in order to cover scenarios like yours in one of the next releases. I am considering this as a feature request and I am updating your Telerik points for bringing our attention on this.

Best wishes,
Martin Vasilev
the Telerik team