This documentation supports the 22.1 version of BMC Helix Innovation Studio.

To view an earlier version, select the version from the Product version menu.

Leveraging full-text and global search capabilities in your application

BMC Helix Innovation Studio provides the capability to enable full-text search (FTS) and global search in an application. FTS involves indexing before searching so that when a user performs a search, only the index is searched instead of the entire text. Global search searches the text in multiple forms across an application. 

This use case describes a scenario about how a manager can leverage FTS and global search to get a list of employees who have availed special leave. 


An organization uses a leave approval application for submission and approval of leaves. A senior manager wants to generate a report that lists the employees from all departments who have availed special leave. 

Roles involved

The following roles are involved in enabling FTS and global search capabilities:

  • Application business analyst—Enables FTS on fields in the record definitions so that users can use FTS to search for data in those fields. Also defines the relevancy of the FTS-enabled fields. 
  • Administrator—Enables global search for an application and performs additional configurations to enhance the search results after the application business analyst enables FTS on certain fields.

Process of workflow

For the manager to perform search across all record definitions in the application, the application business analyst and the administrator enable FTS and the global search respectively. An application business analyst enables FTS on fields such as type of leave, description, name, and department of the leave approval application so that these fields are searchable using the FTS. Then, the administrator enables global search in the leave approval application.

The manager searches for "special leave" in the global search. The global search searches all the records in the leave approval application. 


A list of employees who have availed special leave is displayed. The manager can click on each record and get the details of each leave request. With the search result, the manager can generate a report of employees availing special leave.

Benefits of enabling FTS and global search in an application

Enabling FTS and global search in an application has the following benefits that are not present in a standard database search:

  • FTS can identify stem words and can return the results accordingly. For example, when you search for fire, the search results will include words such as firewall, backfire, firefighter, firecracker, and so on. 
  • FTS can weigh words according to their relevancy depending on where they appear—in a title, a keyword, or the text that is being searched. Results that match the title can be weighted as more relevant and can be displayed among the top search results. 
  • Global search performs a search operation on multiple forms and searches across the application, unlike FTS, which searches within a single form. Global search searches all the fields that are full-text search (FTS) enabled. For example, in this use case, all fields that are FTS enabled will be searched for "special leave."

Where to go from here

Enabling full-text search capabilities in your application

Enabling global search for use in an application

Was this page helpful? Yes No Submitting... Thank you