Apply grid filter from transport string?

[Koen]

Hi!

Can I also apply a filter string representation read from a filter transport.parameterMap?

let grid = $('#myGrid').data("kendoGrid");

// This works, apply filter from object
grid.dataSource.filter({ field: "amount", operator: "eq", value: 7 });

// read the grid' filter as string
let filterstring = grid.dataSource.transport.parameterMap({ filter: grid.dataSource.filter() }).filter;
// value is now "amount~eq~7"

// Q: can something like this be done in some way?
grid.dataSource.filter("amount~eq~1234567"); // bad code

Thanks!

[Patrick | Technical Support Engineer, Senior]

Hello Koen,

To confirm, the Kendo UI DataSource's filter cannot be set using a string value.  But, the Kendo UI DataSource's filter can be configured using an object which has a field, operator, and value defined like what you presented in the snippet.  If you have a string in the format provided(filterString), you can split the string and populate the dataSource filter:

JavaScript

        //reference the grid
        let grid = $('#grid').data("kendoGrid");

        // read the grid' filter as string
        let filterstring = "UnitPrice~eq~18";

        //split the filterString
        var newFilter = filterstring.split("~");

        //set the filter of the Kendo UI Grid's DataSource
        grid.dataSource.filter({ field: newFilter[0], operator: newFilter[1], value: newFilter[2] });

Please let me know if you have any questions regarding the matter.

Regards,
Patrick
Progress Telerik

[Koen]

Since I only require to filter a single member, this works perfect for me.

Thanks!

[Patrick | Technical Support Engineer, Senior]

Glad to hear this solution helped out!