Hi,
I'm trying to customize the filter of a column of date type. By default the filter UI of date type is is an operator type of equal/before/after with a datepicker. But I want the filter to be more powerful. I want to filter by specific date or by number. If it is by date then it is no difference with the default filter. But if it is filtered by numbers (days and hours), I hope it can be filtered by the difference of days and hours between now and the date value in database.
The server side is implemented with ASP.NET WEB API with odata. It seems obvious that the filter parameter passed to the server side should be converted to a date on the client when filtering by day and hour number. To distinguish the filter type between date and day/hour number, I think a switcher is also needed on the UI.
I'd like to know, if this kind of filter customization (a standard UI with an extra filter type switcher, days and hours textbox ) is possible? Is there an api giving me the chance to convert the numbers to a date before submitting for server side filtering?
Thank you for your help!