How to call Filter 'is one of' in Background Script

shaik_irfan · ‎10-17-2017

Hello Everyone,

I have a requirement where i need to check wheather the incident are closed or not, i have more than 1000 records how to run the background scirpt to get count in one shot.

sanjay36 · ‎10-17-2017

Hey Irfan,

You can form the queries in the query builder of the incident list . and then copy the query. by right clicking the filter and copy query like shown below

No write your script.

var gr = new GlideRecord('incident');

gr.addEncodedQuery('incident_stateIN6,7');

gr.query();

while(gr.next()){

// do something;

}

Thanks,

Sanjay

View solution in original post

Kalaiarasan Pus · ‎10-17-2017

http://wiki.servicenow.com/index.php?title=GlideAggregate#addEncodedQuery

Chandu Telu · ‎10-17-2017

you use encoded query like this: active=true^categoryINrequest,inquiry,software

Chandu Telu · ‎10-17-2017

ar gr = new GlideRecord('incident'); gr.addEncodedQuery('active=true^categoryINrequest,inquiry,software'); gr.query(); while(gr.next()){ // do something; }

preddy · ‎10-17-2017

Hi Irfan,

You can check How many Active incidents are there in Incident Table.

var gr = new GlideRecord('incident');

gr.addActiveQuery();

gr.query();

if(gr.next()){

gs.print("Count : "+gr.getRowCount());

}

shaik_irfan · ‎10-17-2017

Pavan,

I have 1000 of correlation_ids with this i need to check how many are Closed & How many are opened. Can you please help me out with this