Use OR statements in REST API URL

[Luca14]

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

[Mike Patel]

you can do below. you don't need _ after OR

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

for Assignment group you need to pass in sysid of group. If you want to pass in name do below

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

[Luca14]

Hi Mike

Thank you for your reply.

I tried but I get the following error:

<response>

<error>

<detail>

null value in entry: state=null Check logs for error trace or enable glide.rest.debug property to verify REST request processing

</detail>

<message>

java.lang.NullPointerException: null value in entry: state=null

</message>

</error>

<status>failure</status>

</response>

[Mike Patel]

try below, it works for me.

https://xxx.service-now.com/api/now/table/incident?sysparm_query=state%3D2%5EORstate%3D3%5Eassignment_group.name%3DGrup-Name

[Luca14]

Really appreciate Mike, it works but this gives me an XML with too much information.

I just try to get the total count of incidents that have not the stauts is not one of resolved or closed