List of CIs that do not start with Generic

[George56]

Hello,

I have a requirement to exclude CIs where the name starts with "Generic" on a field that references the cmdb.  Has anyone successfully used "NOT STARTSWITH" in an encoded query?  If there is another alternative, I'd appreciate any ideas.  Thanks

[Its_Azar]

Hi there @George56 

You can’t use NOT STARTSWITH in an encoded query, so it won’t work as-is. Instead, filter using:

nameNOT LIKEGeneric%

This will exclude any CI whose name begins with "Generic". You can add other conditions after it if needed. Simple and works fine for reference qualifiers and GlideRecord filters.