'Does Not Start With' Operator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-18-2017 03:53 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-18-2017 03:57 AM
Will "does not contain" operator work for this scenario .
-Syed
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-18-2017 04:03 AM
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'.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-18-2017 04:12 AM
Refer this : How to create "Not Start with" condition in filter
It should help :
we can write a script include and call that from the filter.
-Syed
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-18-2017 04:24 AM
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.