When a user has more than 10,000 records the "contains" search in a reference field switches to a "startswith" search.


Steps to Reproduce

1. Create or modify a user's preference by giving the user more than 10,000 user preferences
2. Create a global user preference for autocomplete searches with "contains" - sys_user_group.autocomplete.contains (no specified user)

1. Login to the Instance as that user (or impersonate the user)
2. Navigate to any task record
3. Type in a search where we expect it to perform a contains search

Expected results:
Autocomplete would perform a contains search and return a list of matching results

Actual results:
It performs a starts with search does not return desired results


This can be worked around by one of the following:

  1. Create a new user preference to allow 'contains' (sys_user_group.autocomplete.contains=true) for the specific user 
    2. Precede the search in the reference field with an asterisk for example : '*network' 
    3. Create the 'glide.ui.ref_ac.startswith' on the Instance and set it to 'false'. This will force the 'contains' search globally on the Instance

This problem is currently under review. You can contact ServiceNow Technical Support or subscribe to this Known Error article by clicking the Subscribe button at the top right of this form to be notified when more information will become available.


Related Problem: PRB581188

Seen In

Aspen Patch 2
Aspen Patch 2 Hot Fix 5
Aspen Patch 6
SR - IRM - Audit Management - New York 2019 Q3
SR - IRM - GRC Profiles - Madrid 2019 Q2
SR - IRM - Policy and Compliance - Madrid 2019 Q2
SR - IRM - Risk Management - New York 2019 Q3
SR - IRM - SIG Assessment Legacy - Madrid 2019 Q1
SR - IRM - SIG Questionnaire - New York 2019 Q3
SR - IRM - Vendor Risk Management - Madrid 2019 Q1
SR - ITOM - CMDB CI Class Models - 201908
SR - ITOM - Discovery and Service Mapping - 201908
SR - ITOM - Fundamentals Istanbul Jakarta Kingston r1 - v5.99.6

Fixed In


Associated Community Threads

There is no data to report.

Article Information

Last Updated:2020-09-25 06:49:54