- Predictive Search

Predictive Search

Introduction

The Predictive Search feature in WOW allows the ability to search through 1 or more columns that might include whatever search string a user enters in the textbox. For example, if I want to search through the first name, last name, and middle initial columns in my employee database, I can enter in, “h” and anyone with the character “h” in their first name, last name, or middle initial, will be displayed in those results, in a drop down menu format. This action is very effective to cut down time and from these results, you can narrow down even more, by entering either a character before or after the “h” character to try and narrow the results even more as desired, depending on the data being displayed. You can also input a character like “h” then hit enter and it will display all relevant rows based upon the columns you are searching in.

To view a sample and test drive this feature, please click here.

There are three items that are key to making this work effectively. The three parts are as follows:

• • Derived Field Descriptor

  • SQL Operation

  • Possible Values [PV] Operation

example: Predictive Search end result

example: searching in the names for the letter “K”

TAGS: JQuery autocomplete, type ahead, dynamic search dropdown, suggestions