Define auto complete table columns

Search for	Example	Results
A single word	`cat`	Topics that contain the word "cat". You will also find its grammatical variations, such as "cats".
A phrase. You can specify that the search results contain a specific phrase.	`"cat food"` (quotation marks)	Topics that contain the literal phrase "cat food" and all its grammatical variations. Without the quotation marks, the query is equivalent to specifying an OR operator, which finds topics with one of the individual words instead of the phrase.

Search for	Operator	Example
Two or more words in the same topic	`AND` `and` `+` (plus symbol) `&` (ampersand)	`cat AND dog` `"cat food"+milk` `"cat food"&"dog food"`
Either word in a topic	`OR` `or` `\|` (pipe)	`cat OR dog` `cat \| dog`
Topics that do not contain a specific word or phrase	`NOT` `not` `!` (exclamation point)	`NOT cat` `! dog`
Topics that contain one string and do not contain another	`^` (caret)	`cat ^ mouse`
A combination of search types	`( )` parentheses	`cat + (dog \| mouse)` `cat \| dog + (! mouse)`

Applies to User Roles:

System Administrator

For all fields that have auto complete enabled, their data policy record provides an Auto Complete Table Columns tab, which enables you to define the fields (columns) to display in the auto complete drop-down table for the field. By providing additional key information about the field, this feature helps users easily select the right record from a list of auto complete results.

Tip For a list of fields with auto complete enabled in the out-of-box system, see the Out-of-box Comfill fields with auto complete enabled section in Auto complete.

Note Auto Complete is always enabled for a field that has a referenced table defined, regardless of the value of the comfillAutoComplete parameter and the Auto Complete property setting defined in Forms Designer for that field. For more information, see Auto complete.

For example, when a web client user enters CI information in the reference modules (such as Incident, and Change), a drop-down table for auto complete is displayed, which lists a number of field values of the matching CIs so that the user can easily select the right CI. By default, the Display Name, CI Identifier, Type, Environment, and Assignment columns are displayed in the auto complete table for CI fields, and only one column is displayed for non-CI fields (for example, the Contact field in an Interaction record).

You can customize the auto complete table columns for a field that has auto complete enabled. To do this, follow these steps:

Open the data policy record for the field. For example, if this is a CI field, open the device data policy.

There are several ways to do this. For example, open the device dbdict record, and then click More > Data Policy.

Click the Auto Complete Table Columns tab, and then edit the existing list of fields.

For a CI field, the auto complete drop-down table always displays the display.name field as the first column, even if you delete it from this tab.

For a non-CI field, auto-complete by default uses the target field that is defined in the corresponding link record. If you want to add more columns, be sure to add this field as the first column. For example, for the Contact field in the Interaction form, the Incidents link record defines the contact.name field of the contacts table as the target field. Therefore, if you want to add more columns, you must add the contact.name field as the first column on the Auto Complete Table Columns tab of the contacts data policy record. See the following figures.