Cannot get datasource to acknowledge changes to filter

[Eric]

I have a kendo grid in JSTL format where I'm trying to override a filter choice for date (making the filter look for the span of an entire day like in this example. But setting a simple hardcoded filtergives no results in the kendo grid, even when there are results matching the filter:

let startOfFilterDate = new Date(2000,1,1,0,0,0) 
let endOfFilterDate = new Date(2000,1,1,23,59,59) 
var filter = { 
  logic: "and", 
  filters: [ 
    { field: "date", operator: "gte", value: startOfFilterDate }, 
    { field: "date", operator: "lte", value: endOfFilterDate } 
  ] 
}; 
e.sender.dataSource.filter(filter);

I've tried putting in various places...

1) <kendo:dataSource-change></kendo:dataSource-change

2) <kendo:grid name="search-result-grid" ... filterable="true" columnMenu="true" columnMenuInit="doFilter">

And then my "doFilter" method is pretty much the same as the given example linked to above.

If I console.log the dataSource.filter, it shows that the filters are there. But the datasource is not being updated/refreshed with the filter for whatever reason.

[Georgi Denchev]

Hi, Eric,

Thank you for the provided sample.

As far as I understand your requirement is to intercept the filter before it is applied to the DataSource and modify it? If that is the case, then you can use the filter event of the Grid instead of filterMenuInit.

        filter: function(e) {
          if (e.filter && e.field === "age") {
            // Prevent the default filter action.
            e.preventDefault();
            // Modify the value of the filter from the first input.
            e.filter.filters[0].value = 33;
            // Apply the modified filter to the dataSource.
            e.sender.dataSource.filter(e.filter);
          }
        }

Dojo

https://dojo.telerik.com/@gdenchev/ABIveXeS 

To test the example, you can open the filter menu for the 'age' column. Type '30' in the first input and apply the filter. The row with age '33' will be displayed instead(because the filter has been modified).

Best Regards,
Georgi Denchev
Progress Telerik