How to query multiple values in a 'state'

[Sandeep109]

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

[Hayo Lubbers · Accepted solution]

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

[shloke04]

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

[Sandeep109]

Hi Sholke,

Got the answer from the above replies

Thanks anyways