Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Change the lookup query of List Collectors in Service Portal

Christian Foer1
Tera Expert

I have a catalog item in the Service Portal, where I can select via List Collector some related Records.
Now when I type some characters in the field, i.e. "chri" I get a list of all Records, where the name starts with Christian.
I can see in the Chrome developer Tools, that the query is:

ChristianFoer1_0-1743677307589.png

So my question is, if there is a way to change this query to 


nameLIKE

 

instead of

 

nameSTARTSWITH

so that I also get the Records like "Förster, Christian" ?

 

Best regards
Christian

1 ACCEPTED SOLUTION

Thanks, yes of course * at the begining is the normal way to go, but a pain in the ass for Endusers, who are not Servicenow Experts 🙂

I found a solution for that:

In sys_user_preferences, create an entry with:

ChristianFoer1_0-1744035209960.png

It is documented here:
https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0750081

View solution in original post

2 REPLIES 2

Dr Atul G- LNG
Tera Patron
Tera Patron

Hi @Christian Foer1 

 

As far as I know, you can use wild characters like * or % to search better on any reference field.

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

Thanks, yes of course * at the begining is the normal way to go, but a pain in the ass for Endusers, who are not Servicenow Experts 🙂

I found a solution for that:

In sys_user_preferences, create an entry with:

ChristianFoer1_0-1744035209960.png

It is documented here:
https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0750081