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

Ct111
Giga 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 Expert

 

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.