List collector : use query CONTAINS without add a wildcard

[Sebastien C]

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,

[GopikaPraka]

Hi @Sebastien C , 

Please refer Solved: How can I change the default search on a list coll... - ServiceNow Community , I gave it a try and was able to achieve this.

[Brad Bowman · Accepted solution]

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

[Sebastien C]

Hi Brad,

Thank you for your solution:

It works also without put ref_ac_columns_search=true in variable Attributes

Kind regards,

[Ankur Bawiskar]

@Sebastien C 

You can check and follow steps shared by @Brad Bowman   but remember it would be a global impact in entire instance.

If my response helped please mark it correct and close the thread so that it benefits future readers.