nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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?

Accepted answers

Jonathan Kernan

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.

All comments

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

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.

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!

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.

Shahrukh Khan_a8yquu

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

Narasimha murthy_m50xoh

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

Ashish Sharma_od8lfm

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

Naomi Perez_p71wv4

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

Michal Karpinski

This can be simplifies to

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

jql