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

[Petr Vaníček]

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

[Jean-Théo _Adaptavist_ · Accepted solution]

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

[Petr Vaníček]

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.

[Jean-Théo _Adaptavist_]

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! 

[Petr Vaníček]

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

[Sutapa Basu]

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. 

[Melissa C]

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?

[Sofian]

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

Thank you !

[Enrico Stabile]

issue in linkedIssues("<ID of the ticket>","<link type>")

for example:

issue in linkedIssues("PROJ-123","parent of")

Shows all the tickets which are child of PROJ-123

[Gautam De]

When I tried this, I am getting error 'Issue link type 'parent of' could not be found in function 'linkedissues'

But the below one worked

issue in linkedissues("proj-123")

[Enrico Stabile]

With the "linkedissues("proj-123") you get the ticket as soon as it is somehow linked to the proj-123.

if you want to specify which relation, you gotta type it (check that the relation is spelled like that in your project, or it exists)

[Sutapa Basu]

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

[Melissa]

@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

[Sutapa Basu]

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

[Melissa]

@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

[Karen Lewis]

I know that this is now 2022 and the question was asked in 2019, but JIRA now offers JQL to search by a specific link type. For example, I needed to find all the tickets that are owned by CRM-209 and this is the JQL that does that: 

project = "CRM" AND issueBelongsTo = "CRM-209"