[Solved] Filter row grid refresh question

[Jon]

I have a grid set up to use a filter row. When I type a character in one of the filter row headers, I can see a query being issued on the server side, complete with the text I'm typing applied as a filter in the query. But the grid doesn't update with the results until the user hits enter in the filter box or the filter loses focus (by tabbing or clicking to another control). In addition, this focus change causes a final query to be sent to the database.

I'd like to either have the grid update as the user is typing (making use of the query that's going out), or only query once, when the user hits the enter key or switches to another control, so that the extra queries aren't creating unnecessary load.

Do you have any ideas as to why the grid doesn't refresh until the enter key is pressed or the text box loses focus? Even though it's issuing queries during the act of typing?

Thanks!

[Alexander Popov]

Hi Jon,

The query is done in order to populate the ComboBox used by the filter row. Applying the filter after selecting an item (or losing focus, which triggers the change event) is the expected behavior, however it is possible to update the filter as you type using a custom solution. Here is an example illustrating a possible approach for doing this.

Regards,
Alexander Popov
Telerik

 

 

[Jon]

Thanks very much for the reply and suggestions!

[Willem]

Be great if this was an autoFilter config option on the default cell filters. 

Cheers,
Will

[Alexander Popov]

Hi Will,

Thanks for the suggestion! Feel free to submit it as a feature request on our feedback portal.

Regards,
Alexander Popov
Telerik