Using the query-by-example method

If you do a search inside a form by filling out fields in the form, you are doing a traditional FTS QBE search (for any of the fields that are FTS enabled). The query-by-example (QBE) Match field property affects QBE searches as follows:

• If the property is not set to Equal, appropriate wildcards are added to the search terms automatically.
• If the property is set to Equal, you must add the appropriate wildcards to the search terms.

Users can enter a QBE in any field indexed for FTS, according to the following syntax:

However, the property settings influence how an accrue search works, as shown in the following table.

Setting QBE Match for a field

(Click on the image to expand it.)

1. On BMC Remedy Developer Studio, open the form and select the required field.
2. On Properties section of the field, on the Database property, select the QBE match from the QBE Match drop-down list.

To set the default preference for the QBE match

(Click on the image to expand it.)

1. On BMC Remedy Developer Studio, on the Windows menu, select Preferences.
2. On the Preferences window, on BMC Remedy Developer Studio, select Form.
3. On the Form preferences, select the required Default QBE Match setting to change the preference. 

If you do a search inside a form by filling out fields in the form, you are doing a traditional FTS QBE search (for any of the fields that are FTS enabled). The query-by-example (QBE) Match field property affects QBE searches as follows:

• If the property is not set to Equal, appropriate wildcards are added to the search terms automatically.
• If the property is set to Equal, you must add the appropriate wildcards to the search terms.

Users can enter a QBE in any field indexed for FTS, according to the following syntax:

However, the property settings influence how an accrue search works, as shown in the following table.

Setting QBE Match for a field

(Click on the image to expand it.)

1. On BMC Remedy Developer Studio, open the form and select the required field.
2. On Properties section of the field, on the Database property, select the QBE match from the QBE Match drop-down list.

To set the default preference for the QBE match

(Click on the image to expand it.)

1. On BMC Remedy Developer Studio, on the Windows menu, select Preferences.
2. On the Preferences window, on BMC Remedy Developer Studio, select Form.
3. On the Form preferences, select the required Default QBE Match setting to change the preference.