List collector : use query CONTAINS without add a wildcard

Sebastien C · ‎02-13-2025

Hi,

Could you please tell me if it is possible to use CONTAINS query as we do by prefix keyword by a '*' without typing that symbol on a list collector in a request interface on the Service now portal ? this is more user friendly ?

-> without wildcard *

-> with wildcard *

Kind regards,

Brad Bowman · ‎02-13-2025

These steps to do the same for Reference variables also seem to work with List Collectors:

1. Ensure that the system property "glide.ui.ref_ac.startswith" is set to false.

2. Confirm that ref_ac_columns_search=true is included in the Variable Attributes

3. Create the following user preference:

Name: table_name_being_referenced.autocomplete.contains (i.e. sys_user.autocomplete.contains)

System: checked

User: leave this blank

Type: true | false

Value: true

4. After the user preference has been created log out and back into the instance for it to take effect

View solution in original post

Sebastien C · ‎02-14-2025

Hi,

I updated those things:

And logout / log in

I use Washingtondc patch 9a version

when I use search on user list, I have always a start with logic: