Hello Callam,
This can be achieved by defining the filter property for the sheet.
filter.columns represents an array that defines the filter configuration for each individual column. You need to specify the criteria for the filter - an array of filter criteria for the custom filters. The criteria should contain an object, that provides the operator type and the value. The column array also needs information on the index to which the criteria are applied and a filter type.
In this dojo you will find the modified demo where Client column is filtered for customers with name containing "er" and Shipping columns containing "2".
I hope this helps. Let me know if you have further questions.
Regards,
Aleksandar
Progress Telerik
Get
quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers.
Learn More.