Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

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");
}