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

Ankur Bawiskar
Tera Patron
Tera Patron

@VIKAS MISHRA 

check this link on how it can be done, use advanced ref qualifier and not simple condition as there you won't have that operator

DOES NOT START WITH filter 

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

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

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

 

 

@VIKAS MISHRA 

like this

javascript:'active=true^u_isemployee=true^u_identity_type_code=W^user_nameNOT LIKEext%';

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

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

@VIKAS MISHRA 

Hope you are doing good.

Did my reply answer your question?

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

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader