How to add a new condition "does not startswith" in reference field
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-20-2025 03:47 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-23-2025 02:15 AM
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"
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-20-2025 03:59 AM
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]
****************************************************************************************************************
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-20-2025 04:10 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-20-2025 08:39 AM
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]
****************************************************************************************************************