Thanks for this information really useful!

I have a question: is there any way to save incident using URL? I mean to create and save incident in Opened state using URL in one go.

Thanks in advance.

‘sysparm_query’ is only available for standard records and forms. In the service catalog you can accomplish something similar by using client scripts. Here’s an article that describes how to do that.

https://servicenowguru.com/scripting/client-scripts-scripting/parse-url-parameters-client-script/

Thanks Mark, got it working late yesterday.

You only need one ‘sysparm_query’ parameter in your URL. You also need to use the ‘sys_id’ if you’re using URL arguments. Something like this should work…
incident.do?sys_id=-1&sysparm_query=active=true&sysparm_stack=incident_list.do?sysparm_query=active=true^cmdb_ci=YOURCISYSIDHERE

Having said that, if you’re doing this from a ‘Create new record’ module, then you shouldn’t need to add ‘sysparm_query’ parameters or arguments at all. You can just use the filter on the module definition to supply the values you want to set in the new record.

I tried adding an &sysparm_query=cmdb_ci=sysid

Where sysid is I put the sys id, but it didn’t work. Any suggestions?

Correction from my post regarding interceptor above: better to use; ‘change_request.do?sysparm_query=type=Normal^state=1’ or similar. My sysparm_stack is wrong and not needed for my use case.

Regards,
Scott

I used this trick to set a Change “type” with an interceptor instead of defining a view with an interceptor. The target URL I used:

change_request.do?sysparm_stack=change.do&sys_id=-1&sysparm_query=type=Expedited

Hey Brian,

My experience has been that the ‘OR’ gets evaluated before the ‘AND’. That being the case, your query should return exactly what you think it should if you remove the parentheses.

I wonder if you could give a little more detail about the syntax of the sysparm_query clause in a URL. I’ve recently been trying to use a reference qualifier to do a query that consists of a number of ANDs and ORs for which I would like to be able to use parentheses – but the URL syntax doesn’t seem to allow that. As an example, suppose I want to restrict the list of CIs that are presented when you click the magnifying glass on an Incident form to those where either the Company is as entered on the Incident or the Location is as entered on the Incident, but the Install Status must also be In Service. The kind of sysparm_query I want to generate is:

install_status=1^(company=XYZ Inc^ORlocation=London)

The query doesn’t work with the parentheses there, but without them, how is the query evaluated – is there a precedence such that OR gets evaluated before AND or vice versa? Or are the operators evaluated in sequence from left to right, in which case my query above (minus the parentheses) would return all the CIs that belong to XYZ Inc that are also In Service plus all the CIs that are in London regardless of their Install Status.

Brian