Default language.

Providing a shortcut for specifying expanded FTS qualifications

To provide a shortcut method for specifying expanded  qualifications, add a form search field (a display-only field with field ID 178) to a form. Then, users can use that field to search all full text indexed fields on the form with an expanded OR search. For example, if the Description and Worklog fields on a form are indexed for  and the user performs a QBE search by supplying the search term firewall in a form search field, the qualification generated on the server is:

'Description' LIKE "firewall" OR 'Worklog' LIKE "firewall"

On a form where a single attachment field is the only field indexed for , you can use this feature to provide a QBE search for the attachment field. Otherwise, only the advanced search bar method is available for searching attachments.

Important

Use caution when labeling the form search field so that users do not get the impression that using this field searches all fields on the form. The feature searches only fields indexed for .

 does not support  if you have read-only database. For more information on using read-only database, see Using read-only database.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*