incidents for a particular CI

[chetansriram]

Hi,

How do i view the incidents for a particular CI using advanced relationship query.

[Johns_MP · Accepted solution]

Hi @chetansriram ,
you can use "^ORDERBY" and "^ORDERBYDESC" followed by the field name to sort. See the examples below.
ORDERBYDESCORDERBY

Hit thumbs up if you feel that it was helpful in resolving your query.

[Mike_R]

Just add a query on your Incident table

[chetansriram]

Hi Mike, thank for your quick reply. BTW i am looking for a query to use in Snow Rest API explorer. Attached the screenshot.

[Johns_MP]

Hi @chetansriram ,
if you know the sys_id you can add it in the sysparm_query as shown below(see attached screenshot "with sysid").
with sysid

if you are planning to use the name you can use the below screenprint "with Name"

with Name

Let me know if you need more help on the Rest Api
Hit Thumbs Up if you feel that the answer was useful.

[chetansriram]

Yes This helps.  Is there any sort option to get the incident in the order of when they were opened. like latest first.

Presently the result is sorted as per the incident numbers by default.