question Re: How to query multiple values in a 'state' in ITSM forum

How to query multiple values in a 'state'

Sandeep109 — Sat, 15 Jan 2022 17:52:51 GMT

Hi All,

I wanted to check if an incident record is available with either resolved state or closed state or cancelled state

is below script for querying the table right?

inc.addQuery('state=7'||'state=6'||'state=8'); // is this querying right?? as am not getting the output

Please advice

Regards,

Sandeep

Re: How to query multiple values in a 'state'

vkachineni — Sat, 15 Jan 2022 18:05:35 GMT

Use servicenow UI to generate the queries

stateIN1,2,3

Use

inc.addEncodedQuery('stateIN1,2,3');

Re: How to query multiple values in a 'state'

Saurav11 — Sat, 15 Jan 2022 18:44:22 GMT

Hello,

Please use it as

inc.addEncodedQuery('stateIN6,7,8');

Please mark answer correct/helpful based on Impact

Re: How to query multiple values in a 'state'

Sunny Khandelwa — Sun, 16 Jan 2022 11:57:01 GMT

Hi Sandeep,

Try the below code in Background script. It will give you the count of either Incident resolved or closed or cancelled state.

var incstate = new GlideRecord('incident');
incstate.addEncodedQuery('incident_stateIN6,7,8');
incstate.query();
gs.print("COUNT IS--" + incstate.getRowCount());

If you want some manipulation after this

var incstate = new GlideRecord('incident');
incstate.addEncodedQuery('incident_stateIN6,7,8');
incstate.query();
while (incstate.next()

{

//Your code

}

Re: How to query multiple values in a 'state'

Hayo Lubbers — Sun, 16 Jan 2022 12:34:29 GMT

Hi,

The suggested addEncodedQuery is 1 option.

You can also do it via the addOrCondition:

var grIncident2 = new GlideRecord('incident');
grIncident2.addQuery('incident_state',6).addOrCondition('incident_state',7).addOrCondition('incident_state',8);
grIncident2.query();
gs.print("COUNT IS : " + grIncident2.getRowCount());

Or even via the addQuery with IN:

var grIncident = new GlideRecord('incident');
grIncident.addQuery('incident_stateIN6,7,8');
grIncident.query();
gs.print("COUNT IS : " + grIncident.getRowCount());

Regards,

Hayo

Re: How to query multiple values in a 'state'

shloke04 — Sun, 16 Jan 2022 12:38:43 GMT

Hi,

Where are you writing this code , can you let me know and accordingly can assist you with the sample code to be used.

Regards,

Shloke

Re: How to query multiple values in a 'state'

Sandeep109 — Sun, 16 Jan 2022 18:06:17 GMT

Hi Sholke,

Got the answer from the above replies

Thanks anyways

Re: How to query multiple values in a 'state'

Saurav11 — Sun, 16 Jan 2022 18:10:57 GMT

Hello Sandeep,

Just saw you had marked my answer as correct and then changed it.

Any reason why?