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

Get all Issues without linked issue

nmathias

Is it possible to get a list with all issues without a linked issue inside?

Im using a separate project for all my software-requirments and ideas. Each issue in this project produces additional EPICs inside my other softwareprojects, so each idea causes an related epic.

Now i want to make sure, that every incoming idea has a related EPIC.

Thanks, Nils

Accepted answers

Tarun Sapra

If by *linked issue* you mean no related Epic then you can use the JQL

project = X and "Epic Link" is empty

Here project X can be your project having ideas

Daniel Lowe

Jira (Cloud) now supports this via:

project = xxx AND issueLinkType is EMPTY

All comments

Tarun Sapra

If by *linked issue* you mean no related Epic then you can use the JQL

project = X and "Epic Link" is empty

Here project X can be your project having ideas

nmathias

Thanks Tarun for your quick answer. In my case I'm looking for a solution for this:

project = X and linkedIssue is EMPTY

Tarun Sapra

As of now, JIRA by default doesn't support it. But if you have script runner plugin installed then you can do it via the following JQL

project = X and issueFunction not in hasLinks()

Fabian Bruselat

Do I have to restart something? I installed the trial of ScriptRunner, did the JQL you suggested and get

Field 'issueFunction' does not exist or you do not have permission to view it.

Running Jira Cloud. Is this restricted to Jira Server?

mukul_h6kizo

We can get the list of non-linked issues via CSV download

In the "Search issues" page, in the "Columns" drop-down, select "Linked Issues" option. Now download a CSV with only current fields.
In the downloaded file, use filters and select the "Blanks" option in all the columns of "Outward issue link".

Tom Clement

I had the same problem. I didn't exactly solve it (don't have script runner) but I needed to find all issues without a linked issue. For my purposes with a limited number of issues to filter against, I was able to add the linkedIssue column to the filter. Then it was relatively easy to scan through the results looking for ones without an IssueID in that column.

FYI, the use case here is that there is a project that professional services folks enter issues into. They are vetted there, and all the issues are maintained for tracking. When we decide to take action on one of those issues, it's assigned to a developer. We then create Product Development issue in another project and link them. I needed to find all issue assigned to me that didn't have something linked yet.

Daniel Lowe

@Tom Clement project = xxx AND issueLinkType is EMPTY AND assignee = currentUser()

Daniel Lowe

Jira (Cloud) now supports this via:

project = xxx AND issueLinkType is EMPTY

Tom Clement

Thanks Daniel!

Ravi Chivukula

Just perfect.. I was able to get he list of all issues which had no links.. thanks Daniel!

Daniel Lowe

No worries @Ravi Chivukula

Please upvote my answer 😁

Ravi Chivukula

Just did @Daniel Lowe !

Michelle Werry

I'm trying to write a query that is

Project = XXX and issuetype = EPIC and LinkedIssue is not a specific Issue key but I only get the ~ or ~! as options for the LinkedIssue. I was hoping for a not in selection.

Any ideas?

Daniela Buffarini

try with

project = XXX AND issueFunction in linkedIssuesOf("type =Epic")

if you have ScriptRunner (JSU)

remi.dc

With script runner on JIRA cloud there JQL Keywords feature.

You have to synchronise issues and then you can use in advanced JQL the keyword : numberOfLinks

project = PRJ AND issuetype = Type AND numberOfLinks = 0

See doc : https://docs.adaptavist.com/sr4jc/current/scriptrunner-jql-keywords-functions/jql-keyword-examples#id-.JQLKeywordExamplesvCurrent-numberOfLinks

Welcome!

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

Quick Links

Find more posts tagged with

jira

issue-link