I want to filter time duration column in my Grid, which is displayed using toHHMMSS().
The default filter requires input in seconds, so the user have to type 4810 instead of 01:20:10 to represent 1 hour 20 min and 10 secs.
How can I change it to be user friendly?
1 Answer, 1 is accepted
answered on 22 Dec 2014, 07:20 AM
For the requirement that you have you could either change your data type in the underlying database to a DateTime and use a GridDataTimeColumn with PickerType="TimePicker" or use custom filter template and manually handle the user input and convert it to a valid for the filtering one.
Following are some help articles that could help you with your requirement: