[Solved] Custom date filter (30, 60, 90 day)

[Kevin]

I'm trying to create a custom filter on a date field to show items that have a date in the next 30, 60 and 90 days, including any overdue (i.e. dated in the past).

The current code creates a filter with the needed options, but how can the filters be implemented? The 30 day filter is to be applied when the data is loaded initially.

var pending = [ "60 days", "90 days" ];

var riskFilter = function(e) {
   e.kendoDropDownList({  optionLabel: "30 days", dataSource: pending });
}

$('#current-reviews').kendoGrid({
     theme: 'npw',
     columns: [
          { width: "240px", field: "nextreview", title: "Next Review Date",
           format: "{0:dd MMMM yyyy}", filterable: { ui: pendingFilter } },
],
filterable: {
       extra: false,
       operators: {
          date: {
          lte: "Is due within"
         }
      }
 }

[Rosen]

Hello Kevin,

The scenario you have described is not supported out-of-the-box. To achieve this you will need to unbind the filter menu widgets and handle the creation of the filter descriptors yourself. Here you can find a test page which demonstrates a possible basic implementation of such functionality.

Regards,
Rosen
Telerik by Progress