It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Show list of linked issues from a number of issues

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?

 

 

5 answers

1 accepted

3 votes
Answer accepted

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.

7 votes

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

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

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")

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.

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.

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.

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

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

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.

Is “criteria” a JQL syntax?

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

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!

0 votes

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

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

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted in Jira

Demo Den Ep. 7: New Jira Cloud Reports

Learn how to use two new reports for next-gen projects in Jira Cloud:  Cumulative flow diagram and Sprint burndown chart. Ivan Teong, Product Manager, Jira Software, demos the Cumulative ...

347 views 1 3
Join discussion

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you