How to add a new condition "does not startswith" in reference field

VIKAS MISHRA
Tera Contributor

I already have one reference field created for my catalog item. 

Field is simple reference field and referring the user table and 3 filters are already added there.

Now I want to add one more filter saying (User ID does not starts with "ext") .

Please suggest how can i add this new filter along with exiting one as filter does option does not gives us option to add doesn't starts with.

 

VIKASMISHRA_0-1750416435085.png

 

8 REPLIES 8

In my code i can see in the screenshot its showing "code=W^EQ but seems when you have provided me the code you removed EQ from there, could you please tell me the reason. 

 

One more query i am having that code user_nameNOT LIKEext%'; is meant to say "userid does not contain" howevevr i want this to work like "userid does not starts with". 

Its actually making difference this is the reason i want a code that will work as "userid does not starts with only"

 

Dr Atul G- LNG
Tera Patron
Tera Patron

Hi @VIKAS MISHRA 

 

https://www.servicenow.com/community/servicenow-ai-platform-forum/does-not-start-with-filter/m-p/108...

 

CC: @Anish Reghu 

*************************************************************************************************************
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]

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

This link shows us to add the add query condition, that i am unable to add tin the reference qualifier field space 

If i change the field from simple to advance the it shows like this. "active=true^u_isemployee=true^u_identity_type_code=W^EQ"

 

Please suggest what to add in this code to make it what i want to achieve

VIKASMISHRA_0-1750417788168.png

 

 

yes, is it working for you?

*************************************************************************************************************
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]

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