IQL and JQL: Returning linked JSM tickets to an Insight object

[Juan Du Toit]

Hi,

I need to run a query to return all incidents linked to a specific merchant object (Merchant ID)

Basically using IQL and JQL in one query

Not sure how to do this in cloud or if it's currently possible.  My understanding is that it is possible on the server currently.

Regards,

Juan

[Mathieu Truchot · Accepted solution]

Hi,

I am afraid you're right, there is no easy way to do it.

See below for workaround : https://community.atlassian.com/t5/Jira-Service-Management/How-to-search-issues-linked-to-an-asset/qaq-p/1566920

If someone has a better option I will be  happy too.

Cheers,

[Björn Gullander]

Hi, 

The iqlFunction is also available on cloud. You should be able to use something like the following in the advanced issue search: (Note the single quotes to surround the IQL query)

issuetype=Incident AND MerchantField in iqlFunction(' "Merchant ID" = 1234')