'Does Not Start With' Operator

niitnishant
Tera Contributor

Hi Friends,

I am in process of creating a report on Incident table. Require a suggestion on filter criteria please-

This is the filter criteria below i need to set (along with other simple condtions)-

CIs 'Do not Start With'- SAP , EAS, E1

Assignment Groups 'Do not Start With'- EAS, SAP, DBA, LSG.E1

While there is a 'Starts with' but no 'Does not start with' in ServiceNow. Any experience , thought will be highly appreciated.

Thanks,

Nishant

10 REPLIES 10

syedfarhan
Kilo Sage

Will "does not contain" operator work for this scenario .



-Syed


Does not contain won't, because it's for the characters at any position. - Start, middle, end etc. I am only concerned about the start, hence 'not start with'.


syedfarhan
Kilo Sage

Refer this : How to create "Not Start with" condition in filter



It should help :



Filters



we can write a script include and call that from the filter.




-Syed


Thanks Syed, had seen that thread. Here the issue is i have to run the 'Not start with' logics with other multilple conditions that are very dynamic / changed by users, can't have that flexibility using script.



I am trying my luck with Dynamic Filters.