Does not contain

[Akhil kumar Avu]

Hi,

I want to filter records on incident table with reference field "assignment_group doesn't contain network". 

var gr = new GlideRecord('incident');

gr.query(),

if(gr.assignment_group.name!="net") //I have used this way and tried with indexOf but it is not working.  i want to filter "assignment_group doesn't contain net" through only  if condition not encoded query

{

}         

Thanks in advance!!

[Akhil kumar Avu]

Hi @Voona Rohila 
Thanks for the reply. My requirement to use if condition not querying gliderecord.

var gr = new GlideRecord('incident');

gr.query();

if(gr.assignment_group.name!="network") // like this I want

{

}

Thanks!!

[Voona Rohila · Accepted solution]

Hi 

You can try this

below code check if assignment group name does not have word 'network'  and prints the incident number.

var gr = new GlideRecord('incident');
gr.query();
while(gr.next()){
        if(gr.assignment_group.name.toLowerCase().indexOf('network') < 0){
                gs.info(gr.number);
        }
}

[Akhil kumar Avu]

Thank you @rohil. it worked out

[Muhammad Khan]

Try something like below.

var gr = new GlideRecord('incident');
gr.query();

while(gr.next()){
        if(gr.getDisplayValue('assignment_group').toLowerCase().indexOf('network') < 0){
                gs.info(gr.getDisplayValue('assignment_group'));
        }
}

[Saurav11]

hello,

Please use the below code:-

var gr = new GlideRecord('incident');
gr.addEncodedQuery('assignment_group.nameNOT LIKEnet')
gr.query(),
while(gr.next()) 
{
gs.info(gr.number);
}  

Please mark my answer as correct based on Impact.