How to make assignment rule case insensitive

wbwb
Tera Expert

How can I make these word matches case insensitive?  Here's what I have loaded up so far(see pic) but too many variations in upper and lower case are coming in which make the assignment rule ineffective. Can I use some sort of LIKE statement in there?

find_real_file.png

9 REPLIES 9

RudhraKAM
Tera Guru

add a or condition with caps 

AshishKM
Kilo Patron
Kilo Patron

You can put all 'Short Description' condition-value in single row with OR condition. So either of matching value found, condition will be true.

Currently , your attached image has AND condition.


Please mark this response as correct and helpful if it helps you can mark more that one reply as accepted solution

wbwb
Tera Expert

I need it to find both words.  Not either of them.  What I'm trying to do is catch these different cases in the short description:

 

account, aston

Account, aston

account, Aston

ACCount, ASTon

Or any other variation of case.  I want both words to be searched on but want the case to be ignored.

Michael Ritchie
ServiceNow Employee
ServiceNow Employee

You can use script instead.

var lowerCaseDesc = current.short_description.toLowerCase();
if (current.contact_type == "email" && lowerCaseDesc.indexOf("account") > -1 && lowerCaseDesc.indexOf("aston") > -1) {
	current.assignment_group.setDisplayValue("ASSIGNMENT GROUP NAME");
}