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