54 views

Description

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

shrive_bumbershoot_meritorious_runnel_scapegrace

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:
    shrive_bumbershoot_meritorious_runnel_scapegrace
  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.

 

Workaround

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

There is no data to report.

Intended Fix Version

Madrid

Safe Harbor Statement

This "Intended Fix Version" information is meant to outline ServiceNow's general product direction and should not be relied upon in making a purchasing decision. The information provided here is for information purposes only and may not be incorporated into any contract. It is not a commitment, promise, or legal obligation to deliver any material, code, or functionality. The development, release, and timing of any features or functionality described for our products remains at ServiceNow's sole discretion.

Associated Community Threads

There is no data to report.

Article Information

Last Updated:2018-08-08 06:45:53
Published:2018-02-23