Sysparm_query for getting records from Incident table by 'assigned_to' property

[mstancheva]

Hallo,

Is there a way to filter Incident table via REST API by 'assigned_to.value' property of the records:

"assigned_to": {

              "link": "https://.......service-now.com/api/now/table/sys_user/:id",

              "value": ":id"

} ?

Thanks.

[Alikutty A · Accepted solution]

Hi Mihaela,

You can run this query from your REST API Explorer

sysparm_query: assigned_to.user_name=admin     (This is based on user id of assigned to, If you need a different user attribute then change the field name accordingly)

GET https://instance_name.service-now.com/api/now/table/incident?sysparm_query=assigned_to.user_name%3Da...

Thanks

Please Hit like, Helpful or Correct depending on the impact of the response

[mstancheva]

Thank you very much. a helpful answer