incidents for a particular CI

[chetansriram]

Hi,

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

[johnsmp · 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.

[johnsmp · 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.

[chetansriram · Accepted solution]

Thank you John for your timely help.

[chetansriram]

is it possible to search a word from the short description and load only those incidents.

[johnsmp]

Hi @chetansriram ,
you can use LIKE operator in the same place. See the example below 

"short_descriptionLIKEdesk"

[chetansriram]

Yeah... CONTAINS also gave the result. Thank you.

Is there any document which lists all the available options in "sysparm_query" field.