How to make assignment rule case insensitive

[wbwb]

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?

[wbwb]

Thanks Michael.  Is the script the only way?  Is it possible to configure using the gui?

[Michael Ritchie]

ServiceNow runs on a linux based server and that by default is case sensitive.  There aren't any functions in the condition builder to make it case insensitive unfortunately that I am aware of.

[AshishKM]

Aggregated function like 'toLowerCase' or 'toUpperCase' can be applied only via scripts.

[Chris Bui]

I've solved this by using "matches regex" option in the filter instead of contains.  They don't let you write a fully qualified regex so you have to get creative.

For example, you want the assignment rule to fire when the short_description contains dba, database, or database.

If I were writing a script for this requirement, it would look like this:

var regexPattern = /dba|data\s?base/gi;

But they only let you enter the pattern part and not the flags in the filter condition.

So instead we can do:

.*[dD][bB][aA].*
.*[dD][aA][tT][aA]\s?[bB][aA][sS][eE].*

You could do it all in 1 line but it's not as readable.  Here's how it looks in the platform.

[wbwb]

Cool.  I'll have to try this out when I have a second.  This should really be added as a new feature for these types of filters.