Providing a shortcut for specifying expanded FTS qualifications
To provide a shortcut method for specifying expanded FTS qualifications:
Add a form search field, a display-only field with the field ID 178 to a form.
Use that field to search all full text indexed fields on the form with an expander or search.
For example, if the Description and Worklog fields on a form are indexed for FTS 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 FTS, 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. This feature searches only fields indexed for FTS.
AR System server does not support FTS if you have a read-only database. For more information on using a read-only database, see Using read-only database.