Use OR statements in REST API URL

Luca14 · ‎05-26-2018

Hi

How can I add OR statements by using the following REST API URL:

https://company.service-now.com/api/now/stats/incident?sysparm_count=true&assignment_group=Grup-Name&state=2

I tried the following way:

https://company.service-now.com/api/now/stats/incident?sysparm_count=true&assignment_group=Grup-Name&state=2^OR_state=3

Thanks in adwance

Brian Dailey1 · ‎05-26-2018

Hi Luca,

Your best bet when trying to learn how to write more complex query statements is to view a list on the table of interest, and then use the filter icon at the top to build out your query as desired. Once you have that created, you can simply right-click on the last condition in the filter breadcrumbs and choose "Copy query" to get a properly formatted encoded-query statement.

(copied to clipboard): assignment_group=9939670d6f30b508a4c2211bbb3ee48d^stateNOT IN2,3

Give that a try,

-Brian

View solution in original post

Luca14 · ‎05-26-2018

unfortunately i have no permissions for that 😞

but thank you anyway

Mike Patel · ‎05-26-2018

than try below . That will give you all open INC count for group

https://xxxx.service-now.com/api/now/stats/incident?sysparm_query=stateIN1%2C2%2C4%5Eassignment_group.name%3DGrup-Name&sysparm_count=true

Mike Patel · ‎05-26-2018

try below. you can use stateIN1,2,4

https://xxxx.service-now.com/api/now/stats/incident?sysparm_query=stateIN1%2C2%2C4%5Eassignment_group.name%3DGrup-Name&sysparm_count=true

Luca14 · ‎05-26-2018

Thank you Mike, will try and let you know asap

Luca14 · ‎05-26-2018

Or better, how to use the "Is not one of" - Statement? Is any documentation available about this?

Thank you very much