Enabling full text search in fields

The following table lists the tasks required to enable FTS:

Before you begin

As an application business analyst, make sure you have created a record definition and added the fields for which you want to enable FTSin that record definition. You must define the relevancy of FTS-enabled fields in the inherited record definition.

For more information, see To create a regular record definition and To add indexes for record definitions.

 To enable FTS on fields

1. Log in to BMC Helix Innovation Studio and navigate to the Workspace tab. 
2. Select the application for which you want to use FTS. 
3. On the Records tab, click the record definition that contains the fields for which you want to enable FTS.
4. In the General section, click Add/Remove Search Fields.
5. In the Add/Remove Search Fields dialog box, click Add Search Fields, and perform the following actions:
   • Field—From the list, select the field for which you want to enable FTS.
   • Search Category Name—Enter a search name for the field.
6. Click Save.

 (Optional) To add a search category name to FTS-enabled fields

You can add the search category name only to text fields that are FTS-enabled. 

1. Log in to BMC Helix Innovation Studio and navigate to the Workspace tab. 
2. On the Records tab, select the record definition in which you have enabled FTS on the fields. 
3. Select the FTS-enabled field for which you want to add the search category name. 
4. On the Field Properties  tab, in the DETAILS section, in Search Category Name, type the search term for the selected field.
   For example, If you have selected the Description field, you can add an issue as the search category name. 
5. Click Save. 

How search relevancy works for FTS-enabled-fields

After you have enabled FTS on the required fields, you can define the relevancy of the FTS-enabled fields.

You can add the fields that represent the title, system environment, or keyword in the record definition. The default relevancy that is based on the number of occurrences starts with the title field in the record definition (highest), followed by keyword fields, and then environment.

For example, when the end user performs a search, the search results display the records in the following order:

1. The most relevant items that contain the most occurrences of the word or phrase entered in the Title Field
2. The items with the text in the Keywords Field
3. The items with the text in the Environment Field

 (Optional) To add the search relevancy for FTS-enabled fields

1. Log in to BMC Helix Innovation Studio and navigate to the Workspace tab. 
2. Select the application for which you want to use FTS. 
3. On the Records tab, click the record definition that has FTS-enabled fields. 
4. Select Record properties > Search. 
5. In the Title Field list, select the field that represents the title of the record definition.
   For example, you can select Case Summary because the text entered in this field is more likely to represent the title. 
6. In the Environment Field list, select the field that represents the computer environment. 
   For example, you can select Operating System because the text entered in this field is more likely to represent the environment. 

7. In the Keywords Field list, select the field that represents the search keywords. 
   For example, you can select Description because the text entered in this field is more likely to contain search keywords. 

   Important

   • Make sure to add only one relevancy to each field. 
   • If you are unable to see the FTS-enabled fields in the Title, Environment, or Keywords fields, make sure you have saved the record definition after enabling FTS on the fields.
8. Click Save.