Show list of linked issues from a number of issues

[Jonathan Kernan]

Hi there,

I am using JIRA 6.3 and have a question regarding JQL Queries.

Is it possible to build upon this query :

issue in linkedIssues(ABC-123)

which displays all the issues linked to a single issue? 

What I would like to do is essentially pass in mutiple issue keys instead of one which are based on a separate query. So, what im looking for is something like :

issue in linkedIssues(<subquery>)

Can this be done somehow?

[Jonathan Kernan · Accepted solution]

Created a filter to retrieve a list of issues containing issue links and called this X. 

Used this filter to get all linked issues and filtered out like this: 

issuefunction in linkedIssuesOf('filter = X') AND issuetype in (Bug)

I did'nt realise you could supply the linkedIssueOf() function with a filter until now.

Thank you all for the help.

[Naomi Perez]

issuefunction is not a variable that I'm seeing available.

[Michal Karpinski]

This can be simplifies to

issueFunction in linkedIssuesOf("issue =TICKETID-1")

[Peter Bengov]

Yes, this is possible if Script Runner is installed. You can use something like

issueFunction in linkedIssuesOf("status = Open", "blocks") and resolution is empty

This is like issueFunction in linkedIssuesOf(<subquery>,<link type>) and <more filtering of the results> 

See more info here: https://jamieechlin.atlassian.net/wiki/display/GRV/Scripted+JQL+Functions#ScriptedJQLFunctions-IssueLinks

[JamieA]

The second argument is optional, if omitted it will show issues linked with any link type.

[Jonathan Kernan]

So I have a list of issues of type "Improvement" and want to find all issues linked of type "Bug" Can I combine the default JQL with scriptrunner functions like this: issuetype = Improvement AND fixVersion = X AND project in (A,B,C) AND issueFunction in linkedIssuesOf("issuetype = Bug")

[Peter Bengov]

You can. Just make sure that if you are using linkedIssuesOf you specify link type (inward or outward). Possible values are: blocks, is blocked by, clones, is cloned by, duplicates, is duplicated by, is Epic of, has Epic, relates to.

[Jonathan Kernan]

Hi Peter, I don't really care about the link type. I want to get all linked issues like Jamie mentioned above. Just need to make sure i'm selecting issues of type "Improvement" and within these, get all issuslinks of type "Bug" only.

[Jonathan Kernan]

I have a filter called 'JK' getting all issues for a certain fix version and issue type and stored this in a filter. Something like this: issuefunction in subtasksOf("filter = 'JK'") and issuetype in ("Bug") subtasksOf(filter) looks at all the sub-tasks as opposed to the issues linked to a certain issue. It would be ideal if I could return all linked issues based on a filter.

[JamieA]

issueFunction in linkedIssuesOf('filter = "JK"') and issuetype = "Bug" ?

[Narasimha murthy]

is there any work around for the query to "get the list of issues which has linked issues" with out using issuefunction ?

[Mike Doolittle]

Not to resurrect and old thread, but this might be a good solution for people still searching:

criteria=mycriteria and issueLinkType is not empty 

This should produce a list of issues that meet mycriteria that *are* linked to other issues.

[Sayantan Pal]

Is “criteria” a JQL syntax?

[Matt]

Thanks Mike, that's super useful!  Glad I scrolled to the bottom of this question.

[Ashish Sharma]

Sadly issueLinkType doesn't support is not operator, and i think it never has.

[Vanessa McGonigle]

@Ashish Sharma maybe try issueLinkType not in ()

[Ashish Sharma]

@Vanessa McGonigle Won't it show issues without any linking also? Can you share full query which you tried?

[Vanessa McGonigle]

It seems the query I used for my own jira instance allows issueLinkType is not EMPTY

Maybe atlassian updated the function?

[Fernando Llaca Romero]

Hi ,

You can try a free plugin I've made: Easy Links for JIRA. It provides two new custom field types: Single Issue Link Picker and Multiple Issue Link Picker. These custom fields are displayed as dropdown select lists, which you can filter and autocomplete by typing on it (see screenshots). Also, you can configure the customfields to restrict the available issues to select (using a JQL expression when creating the custom field), and the link type that the field will be associated to. When you select a value, a new issue link is created between the current issue and the selected one(s), that you can manage as a regular issue link.

In addition, you can use the custom field in JQL queries (for example: "Blocking Task" = TEST-123), and in dashboard gadgets (pie charts, filters, etc).

I hope it can solve your issue,

greetings!

[Shahrukh Khan]

How can I get the list of tickets which have some linked issues?

[Narasimha murthy]

As Answered by Peter B , its like this issueFunction in linkedIssuesOf(<subquery>,<link type>) and <more filtering of the results> 

Eg : 

issueFunction in linkedIssuesOf("status = Open", "blocks") and resolution is empty