Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,300,003
Community Members
 
Community Events
165
Community Groups

How to search all linked issues with issues from specific project and with specific link type

Hi,

I got interesting question from my collegue, but I'm not sure how to procede his request.

By my short testing with JQL I found this:

issue in linkedIssues(DEFDEV-644) 

But I need something like this (not working JQL - just idea behind it. So I want all issues from all project where are issues linked with any issue in project DEFDEV by link issue type "Realized by".

issue in linkedIssueProject(DEFDEV) and linkType = "Realized by" 

 Do you have any idea ho to do this (with or without add-on - doesn't matter).

Thanks

Petr

5 answers

1 accepted

Hello Petr,

You can do this if you have Scriptrunner installed:

https://community.atlassian.com/t5/Jira-questions/How-to-find-all-issues-that-have-a-link-type-CLONE/qaq-p/32959

issuefunction in hasLinkType("Cloners") and issue in linkedIssues(DEFDEV-644)

 You just need to change the link name!

Hope this helps,

JT

I think it's not what he need. 

He need issues from whole Jira which are linked with any issue from specific project by specific link type.

I just tried look into Scriprunner documentation, but I'm not sure which JQL function use for this use case.

I think I misunderstood your initial question, it is clearer now!

The function you need is probably linkedIssuesOf.

You can achieve what you need with something like :

issuefunction in linkedIssuesOf('project = projectName', 'is cloned by')

 But this function uses a one direction link, if you need both directions, you can use something like :

issuefunction in linkedIssuesOf('project = projectName', 'is cloned by') or issuefunction in linkedIssuesOf('project = projectName', 'clones')

I hope this answers a little more your question! 

Like # people like this

It looks like it's exactly what we want, thanks.

Like Jessica Borges Alves likes this

I actually find a easier way to find the linked items just by adding the links column on my search result. 

Thanks for all you suggestions. 

Hi,

I am trying to build search filter with JQL query where I need to see the list of all link items for specific sprint. Any idea how i can accomplish this task?

 

Thanks

@Sutapa Basu 

sprint = XXXXX

You will need to find the Sprint ID and this will give you all Jiras in that Sprint.

You can also see if it will autofill so if you type sprint then choose = and begin to fill in your sprint name it might autofill.  

Hope that helps

Thanks, I understand the sprint= SprintID will give me all the items in the current sprint, but I like to if there is any prior linked item for any of the item listed for the sprint.

 

Thanks

@Sutapa Basu 

Try 

issuefunction in hasLinkType("Link") AND Sprint = XXXXX

 

I would do "Sprint is not EMPTY" so it shows everything and then I would narrow it down

Let me if that works

Hello Everyone!!!

I wanted to build on this query but I'm not sure if it is possible in Jira Server 7.13.

issue in linkedIssues (XYZ-2222) AND project = "Product Management"

This gives me any linked issues in XYZ-2222 but only those Issues in the Product Management Project.  Thanks for posting this answer!


I wanted to take it a step further,  For the results of this query I want to see any Tasks/SubTasks, I tried using the parent() function but I wasn't able to nest it properly.  

Is this possible out of the box? 

Does anyone have any suggestions on how to do this?

Great !, I found this answer just at the right time. It works perfectly.

Thank you !

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