is there a way to exclude items that start with a string from reference qualifiers?

jimdawson
Giga Contributor

I have a need to present a reference variable on a catalog item where a value does not start with certain strings.

e.g. suppose I need to exclude users named 'Bob' from being selected.

I can do:

'NAME' starts with 'Bob' OR

'NAME' starts with 'Robert' 

and get a list of the users I want to exclude, but I can't show a list of everyone except that query.

I tried using the 'matches regex' and 'matches pattern' qualifiers but as far as I can tell neither of these qualifiers work.

 

Is there a way of doing this? or is there a super-secret method to make 'matches regex' work?

Thanks in advance.

 

1 REPLY 1

Ankur Bawiskar
Tera Patron
Tera Patron

Hi,

something like this

javascript: 'nameNOT LIKE' + 'StartString%';

reference: https://community.servicenow.com/community?id=community_question&sys_id=0112d2df1ba5585017d162c4bd4b...

Regards
Ankur

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader