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!!

[Murthy Ch]

Hi @Akhil kumar Avu 

If you don't want to use via encoded query then you have to use add query like below:

var grI=new GlideRecord("incident");
grI.addQuery("assignment_group.name", "DOES NOT CONTAIN", "network");
grI.query();
while(grI.next())
{
gs.info(grI.number.toString());
}

Hope it helps.

[Akhil kumar Avu]

Thank you for quick reply. I don't want to use addQuery also. I want to filter through if condition. Please help on this.

[Mohith Devatte]

Hello @Akhil kumar Avu ,

try this script 

in the script replace your network assignment group sys_id.

To copy the sys_id go to sys_user_group.LIST table and then search for network record and then right click on it and copy the sys_id like below 

var gr = new GlideRecord('incident');

gr.addEncodedQuery('assignment_group!=287ebd7da9fe198100f92cc8d1d2154e'); //replace network group sys_id

gr.query();

while(gr.next())

{

//your logic

}

Hope this helps 

Mark my answer correct if this helps you 

Thanks

[Voona Rohila]

Hi @Akhil kumar Avu 

you can use 'NOT LIKE' in the query.

Try this 

var grI=new GlideRecord("incident");
grI.addQuery("assignment_group.nameNOT LIKEnet");
grI.query();
while(grI.next())
{
gs.info(grI.number.toString());
//do something.
}