Configure Kendo Grid Search Toolbar to filter only visible columns?

[Philip]

I have a kendo grid which has the search filter enabled. I notice the search filters data based on the hidden columns as well. I'd like to have the search bar filter data based only on the visible columns. Is there a way to do this?

[Nikolay]

Hello Philip,

You can specify the visible column to be included in the search by including them in the search.fields list:

search: {
              fields: ["Freight", "OrderDate", "ShipName", "ShipCity"]
            },

Here is a Dojo demo demonstrating this: https://dojo.telerik.com/ErISoxIz

Regards,
Nikolay
Progress Telerik

[Philip]

Hi Nikolay,

Thank you for providing a solution. In the Kendo Grid there is an option in the column's context menu to show and hide columns. Is there an easy way to have the Grid search only the visible columns that the user dynamically chooses to show?

[Nikolay]

Hi Philip,

I am afraid this is not available built-in and to achieve this you will need to implement a custom filtering with a single text box and modify its logic when the user hides/shows a column in the columnShow/columnHideevent handlers.

Regards,

Nikolay