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; } } }

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

Accepted answers

Jean-Théo _Adaptavist_

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,

All comments

Jean-Théo _Adaptavist_

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,

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.

Sofian_3e8zz0

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

Thank you !

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?

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_oqnbbr

@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_oqnbbr

@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

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.

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)

Brock Jolet_wkfaaa

Is there a way to use the "issue in linkedIssues()" function by specifying the link type id instead of a string that might change?

lila_mmw63l

project = ZZZ and issuefunction in linkedIssuesOf('project = xyz')

The suggested formula doesnt seem to work? Im after looking up all tickets that are in project ZZZ and have a linked issue in project XYZ.

Anyone tried the formula?

Welcome!

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

Quick Links

Find more posts tagged with

server

jira

jira-server

jql

atl-gruland

issue-link