'Does Not Start With' Operator

[niitnishant]

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

[Filip Vojt__ek]

Hi Apoorva D,

I have noticed your reply just now. So sorry for late reply.

You need to add those using AND logical operator like
'Name DOES NOT START with ECAB AND Name DOES NOT START with Knowledge AND Type DOES NOT CONTAIN 704093f22b08224072751cf405da1599'

That should be quite easy to adjust:

var l1 = new GlideRecord('sys_user_group');

l1.addQuery('name', 'NOT LIKE', 'ECAB%')
l1.addQuery('name', 'NOT LIKE', 'Knowledge%');
l1.addQuery('type', 'NOT LIKE', '704093f22b08224072751cf405da1599'); 

l1.addQuery('active', true);

l1.query();

while(l1.next()){

    gs.print(l1.getRowCount());

    gs.print(l1.name);

}

[raulgonzale]

I have same need... As it's possible to filter records that "starts with", would be extremely useful being able to filter records that "does not start with". Doing that using operator "does not contain" doesn't reflect what you want to filter out since value could be wherever in the field to be compared with.

Definitively should be added to standard operators to create reports.