We're reclaiming inactive PDIs to keep them available for active builders. Learn what's changing, who's affected, and how to protect your work. Read More

How to do case sensitive search in lists?

Krishna119
Kilo Contributor

* does a case-insensitve contains search. =, >=, % all are case-insensitive. Filters are also case-insenstive.

How can i do a case-sensitive search in Lists?

2 REPLIES 2

JerryJ071847183
Tera Sage

I doubt so , you might pull up case sensitive in condition boxes may be

as mentioned in below link

https://community.servicenow.com/community?id=community_question&sys_id=75d3cba5dbd8dbc01dcaf3231f96...

 

Otherwise by default this is what platform supports

Available list search wildcards
WildcardDescription

*search-term

%search-term%

Search for values that contain search-term.
%search-termSearch for values that end with search-term.
search-term%Search for values that start with search-term.
=search-termSearch for values that equal search-term.
!*search-termSearch for values that do not contain search-term.
!%search-termSearch for values that do not end with search-term.
!=search-termSearch for values that do not equal search-term.

 

Mark my ANSWER as CORRECT and HELPFUL if it helps

reshmakore57046
Tera Guru

 

Hello,

 

Follow the below steps - 

1. Create a new field (e.g., u_exact_name) of type string on your table.

2. Use a Business Rule to copy the case-sensitive value from your original field:

javascript
// Before Insert or Update Business Rule if (current.name.changes()) { current.u_exact_name = current.name; }
3. Add  u_exact_name to your list layout.
4. Now, use the = operator in the filter
 
Regards,
Reshma Kore.