This topic is locked

Disabling 'Any Field' Ajax Suggest On Search

4/5/2011 4:49:37 AM
ASPRunnerPro General questions
R
rascasse83 author

Is there a way to disable the 'Any Field' option of the AJAX suggestive search functionality and yet allow all the other suggestive searches (based on named columns) to work ?

On a list screen with AJAX Suggest On Search switched on, a drop down is shown populated with the list of columns to search on, and also an option 'any field'.

While this is convenient from a - lazy - user point of view, it is not from a database performance point of view (a SQL trace shows what everyone suspects, that it does a look up SELECT statement of all the columns in the screen, one by one, and for each character typed by the user).
Being able to deactivate this feature would be very usefull from a performance point of view.

Sergey Kornilov admin 4/7/2011

Take a look at this article in the manual that explains how to do that:

http://xlinesoft.com/asprunnerpro/docs/ajax_based_features.htm