How to include range of values in Aggregate API URL query using key-value pairs?

adsch · ‎07-29-2015

In querying records via the Aggregate API, it is possible to specify a range of values when using the sysparm_query parameter.

For example, a query for active incidents that are in a state of 12 or 2 would be (instance).service-now.com/api/now/stats/incidents?sysparm_count=true&sysparm_query=active=true^stateIN12,2.

However, when doing the same query using key-value pairs, this doesn't work. I thought it would be (instance).service-now.com/api/now/stats/incidents?sysparm_count=true&active=true&state=12&ORstate=2, since that's what the filter is in the ServiceNow instance. But this only filters for the first part, state=12, so it's not working.

What is the proper way to write this query using key-value pairs? I need to use key-value pairs in this case because it allows for using display values for fields, which is necessary for another part of the particular query I am using.

I know I could group by the state field and retrieve the count values for each of the desired states in my code, but it would be a lot easier to do this in one query as when using the sysparm_query.

brian_quinn · ‎07-31-2015

Sorry I misunderstood you. Unfortunately as far as I can tell the REST API key/value pair filtering does not currently support OR conditions. It looks like it is generating a list of URL parameters (separated buy the &) and passing those parameters directly into a addQuery(key, value) function call.

So the URL key1=value1&key2=value2&ORkey3=value3 turns into:

addQuery("key1", "value1");

addQuery("key2", "value2");

addQuery("ORkey3", "value3")

You can use a combination of key/value pairs and sysparm_query to filter by the display values of some fields, but unfortunately it doesn't look like there is a way to add OR conditions using display values.

(ie api/now/stats/incident?sysparm_count=true&sysparm_query=active=true^ORactive=false&assignment_group=Software)

Thanks

Brian

View solution in original post

Falk Hohmann · ‎04-11-2023

is this still not possible?