See issues where a linked issue has a certain value

Question

Hi,

I can't work out how to write a query in JQL to show a list of issues where the value of a field of a linked issue is a certain value i.e.

We have an issuetype of 'Role' and an issuetype of 'Candidate application'

We have a field on a Role issuetype called a 'hiring manager' (Text Field (single line))

I would like to return 'Candidate applications' where the 'Hiring Manager' value on the Role is equal to a string i.e. David Leach

There doesn't seem to be any JQL methods that enable you to search the values of the fields within a related issue (Issue Links - relates to)

Any ideas?

David Leach2 · Answer

Brilliant, thanks.  Any ideas if something like this is available for ondemand?

Luther Hargrove · Answer

I would check this out:

https://marketplace.atlassian.com/plugins/org.craftforge.jira.craftforge-jql-functions-plugin

It's a paid plugin, but it's pretty powerful when trying to build queries around linked issues.  You can always try the trial to see if it works for you.