Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

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

Get list of linked issues - how to?

Hi All,

some project leads of our user community faced us a difficult request. They want to get all linked issues for a particular ticket in JIRA. We know that there is such a JQL query for parent-sub tasks: "parent=..."

How to get the linked issues? We are aware of the Linked issues column but they need a list of issues row by row.

Is it somehow possible?

Thanks in advance,

Rumi

8 answers

1 accepted

issue in linkedIssues(issueKey)

or

issue in linkedIssues(issueKey,linkType)

Hi Jobin,

thanks a lot!

Hi 

i am not getting the linked issue by using the format you have shown.

 

My Code is:

def finding_link(self):
    a = self.jira.issue in linkedIssues('FLAS-54')
    print a,'-------'

Like Marlene Martins likes this

Hi

Thanks a lot!

Is there way to pull related links based on an issue key prefix? This will help to find tickets that have a dependency or blocked a specific project(s)

for example: 

PM wants to find other projects that are dependent on her projects 

Query 

issue in linkedIssues(project key,linkType)

issue in LinkedIssues ("PROJA", "blocked by"

Like # people like this

Could someone provide an example? I am trying to list all linkedissues for a particular release. The details I am looking for are issuekey and issuetype

 

An example would be similar to the following

project = ABC or issue in linkedIssues(TEST-123) ORDER BY Rank ASC
Like # people like this

Thank you for this. I've been looking for over an hour for this solution.

Thank you for your help. 

@David_Schokker is it possible to list several issues inside the linkedIssues()?

Like # people like this

Ticket 1 is created and has a linked ticket.   When the Linked to (relates to) ticket is closed, we'd like to transition the status field of TIcket 1 to a different status.

Is there a JQL command for linked tickets like this scenario?

Regards.

What about searching for all issues (Stories or Sub-Tasks) with linked issues?

Hi John, I´m trying to get the results you´re looking for but with somthing more. I´m searching for closed or resolved Issues with open sub-tasks or blocking linked issues. I´m using the follow query:

 

project = "project" AND fixVersion in (version) AND issuetype in (Story, Bug, "Bug Subtask") AND status in (Closed, "Resolved") AND issueFunction in parentsOf("project = 'project' AND status in(Open, 'In Progress')") OR issueFunction in linkedIssuesOf("project = 'proyect' AND status in(Open, 'In Progress')", blocks)

But already the results include some stories with In Progress or Verified status and I don´t know why? Somebody have an idea?

Andy Heinzer Atlassian Team Mar 17, 2021

Hi everyone,

We have identified this question as having lots of views, but not all users find this to be helpful. In an effort to try to improve the quality of this post, here is a new answer that should help address this common question.

At the time this question was originally posted, Jira was a bit more limited in the native JQL functions that could help here. So I hope that an updated answer can provide more accessible solutions to more users.

 

Searching for issues linked to a known issue

Jira Cloud and Jira Server / Jira Data Center

First up is the linkedIssues() function. This is one way that you can find all the issues that are linked to a specific issue key. So for example you can use a syntax of

issue in linkedIssues(ABC-123)

And JQL search results will show you any issues linked to ABC-123 (that your account has permissions to view). You could also specify the directional link type in this query with an additional parameter such as:

issue in linkedIssues(ABC-123,"is duplicated by")

Which then only shows you issues that have the ‘is duplicated by’ link type to that specific issue of ABC-123.

 

Jira Cloud and Jira Server / Data Center 8.0.0+

Let’s say that you do not know the issue key yet, but you still want to try to find all issues that have a particular linktype. As of Jira Server 8.0, you can now search JQL for issues that have a certain linktype. The IssueLinkType function can search for issues that have at least one of these linktypes. For example you can search

issueLinkType = "is blocked by"

To find all issues that have that specific directional link. Or you could search multiple link types such as:

issueLinkType in (duplicates,"is duplicated by")

To find both issues with a duplicates link or the inverse ‘is duplicated by’ link.

 

Searching for issues in an Epic

Issue linking in Jira can be confusing for some because of there are some link types that are not represented within the functions above (such as subtasks, or Epics). But this is because these are special relationships for issues in Jira. Epics are only a part of Jira Software, but can contain issues from another project type. Conversely subtasks have a requirement to always have a single parent issue in the same project.

You can find all the issues in an Epic using the Epic Link field. This field can accept either the issue key of the epic or the Epic Name, so that an example of this search could be:

"epic link" = XYZ-31  (where XYZ-31 is the issue key of that Epic)

or

"epic link" = Jupiter (where Jupiter is the Epic Name)

Jira Cloud only:

If you are looking for epics and subtasks, then the linkedissue function might be a better resource here.

linkedissue = epicKey-123

Searching for all subtasks on a particular issue? The Parent field can help find these easily in Jira Cloud. A search of

parent = TEST-1234

will return all subtasks of a particular issue in classic projects or subtasks of a particular epic in next-gen projects.

I hope this helps.

Andy

Hi,

Does the query only work with 1 issue key? i.e. I can't seem to search
issue in LinkedIssues(ABC-123, ABC-124, ABC-125, etc.)

Andy Heinzer Atlassian Team Mar 26, 2021

@Hong Nguyen Yes the linkedIssues() function is only able to accept a single issue key as input.

Like Hong Nguyen likes this

Hello All,

 

Does something like this should for in cloud?

 

issue in linkedIssues("project = "X" AND fixVersion = BETA")

Dear Gino

 

we are not using fixVersion field - anyway I am not able to understand why I need to add that field to look for linked issued.

 

I need this to list a Service Desk Ticket and all the connected internal tickets.

 

regards

 

f.

Like # people like this

dear all

 

I am trying to a have a dynamic list from Service Desk issue list where I list all the SD issues that have not linked to a proper issue in our JIRA software.

 

I did not understand how to extract the list of open issues - for a specific project - not linked to any issue.

 

Any idea?

 

regards

 

f.

Hi All,

I am trying to get Issues that are linked to another JIRA Project (and not specific to any jira issue). Does wildcard works in Linked issues?

My Requirement: Get all the issues in jira PROJECT1 that are linked to jira PROJECT2

issue in linkedIssues("PROJECT2*")

Used the Script Function and it works as expected:

issueFunction in linkedIssuesOf("project = Project2")
Like # people like this

I have tried this way (issue in linkedIssues("project = PS")) but it did not work and I had the error message : 

Issue 'project = PS' could not be found in function 'linkedIssues'.

Has anyone tried this function successfully?

Thanks

Yes, it does work for me; I have been using this in Biggantt chart and Kanban filters.

Do check:

1. "PS" is a JIRA project key

2. Your formula needs a small corrections: its "issuefunction" AND "linkedissuesof"

(issuefunction in linkedIssuesof("project = PS"))

Hi Rahul Mittal,

1. Yes, PS is a project key

2. I don't have the Script Runner so the issuefunction  and the linkedIssuesof do not work.

I've watched in the doc for linkedIssues(), it can't have a filter as parameter.
I have to look for another way

Thanks

Like Divya Dias likes this

Hi @NA  I have the same exact request and issue as you.   Did you find another way other than using linkedIssuesOf ?

Suggest an answer

Log in or Sign up to answer
TAGS

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