Words containing underscores are broken into separate words during indexing. So for example if you had a word like this in your record:


It would be split into the following terms:

- shrive
- bumbershoot
- meritorious
- runnel
- scapegrace

If one of the terms is a stop word, all searches for the original word will return zero results.

Searches for the separate words, which are not stop words, will still return the relevant record.

Steps to Reproduce



  1. Navigate to System Definition > Text Indexes
  2. Open the text index for the sys_user table
  3. In the "Index Stop Words" related list click New
  4. Fill out the form as below:
    - Index: sys_user
    - Word: bumbershoot
    - Stop mode: Index but do not query
  5. Submit
  6. Navigate to User Administration > Users
  7. Open any user from the list and change their last name to the following:
  8. Return back to the user list and add the following filter:
    Keywords -- are -- shrive_bumbershoot_meritorious_runnel_scapegrace

No records are returned from the search, because of the "bumbershoot" stop word included.



This behaviour is by design in the current search engine. This problem has been identified as a future product enhancement. Please Subscribe to this article to be notified in case of future updates.

As a workaround, searching for the separate words, which are not stop words, removing the underscores, will return the expected records.


Related Problem: PRB830497

Seen In

London Patch 6

Fixed In


Associated Community Threads

There is no data to report.

Article Information

Last Updated:2020-01-08 13:16:57