We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Turn of autocomplete in Filter Menu

Thread ID:





132388 Aug 30,2017 12:51 AM UTC Aug 31,2017 05:11 AM UTC ASP.NET Core 3
Tags: Grid
James Wilkinson
Asked On August 30, 2017 12:51 AM UTC

I have a Grid with a data source that has millions of records.  I use the UrlAdaptor with paging to avoid querying the whole table.  I added a Menu Filter to the columns of the grid.  Now when I start typing in the text box the system runs a query with RequiresCounts = false, Skip=0 and Take=0 when . This results in a full table query which takes up to 30 seconds.  My guess is this is to populate the suggestions dropdown.

Is there a way to stop this query from running at the View.  If not then I guess I can trap this situation in the controller and just return no records.


Saravanan Arunachalam [Syncfusion]
Replied On August 30, 2017 08:37 AM UTC

Hi James, 
Thanks for contacting Syncfusion’s support. 
We have analyzed your requirement, we understood from your query, you need to place the ejDropDownList instead of ejAutoComplete in the menu filter dialog and we have already discussed this query in the following knowledge base document. 
Or, if you want to render the ejAutoComplete with empty record, we suggest you to set the empty array to its dataSource which doesn’t make the post back for autocomplete’s search and it does show the empty suggestion list. Please refer to the below code example. 
function create(args){ //Create event of Grid control 
            this.element.on("mousedown", ".e-gridheader .e-filtericon", function () { 
                    //open event of the filter menu dialog 
                    open: function (e) { 
                        var dp = this.element.find(".e-autocomplete"), instance; 
                        if (dp.length) { 
                            instance = dp.data("ejAutocomplete"); 
                            instance.option("model.dataSource", []); 
Saravanan A. 

James Wilkinson
Replied On August 30, 2017 02:10 PM UTC


I opted for setting the dataSource to null.  But I had to add the following inside the "if" statement to remove the annoying "No suggestions" results box.

instance.option("model.showEmptyResultText", false);


Saravanan Arunachalam [Syncfusion]
Replied On August 31, 2017 05:11 AM UTC

Hi James, 
Thanks for your update. 
Yes, you can set the “showEmptyResultText” as false to hide the suggestion box and we are also happy that the provided information helped you. 
Saravanan A. 


This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon