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

[Daniel Lowe · Accepted solution]

Jira (Cloud) now supports this via:

project = xxx AND issueLinkType is EMPTY

[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 !

[Chrisjir Parkin]

I like this answer.  What release of Jira supports this?  I tried a JQL query with this phrase and it failed.

[Daniel Lowe]

@Chrisjir Parkin Jira Cloud supports it, I'm unsure which if any version of Server does sorry.

[BJHUDY]

This worked perfectly, thank you! 

[Anette Unger]

my message: The operator 'is' is not supported by the 'issueLinkType' field.

[Farzin Karthik]

Tried this

project = "xyz" AND IssueType= Story AND status in ("Ready for UAT","Done","Closed") AND Sprint in ("Sprint 1", "Sprint 2", "Sprint 3") AND issueLinkType != "Test" AND labels != NotRequired

It still brings up all the stories which has a Zephyr Test linked to it.

[Daniel Lowe]

@Farzin Karthik I imagine that's because Zephyr Tests are treated differently to standard Jira issues.

[Tarun Sapra · Accepted solution]

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?

[Fabian Bruselat]

NVM. found out that it's not working in Jira Cloud. Any idea how I can achieve this in Jira Cloud?

[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

[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()

[Tom Clement]

Thanks Daniel!

[mukul]

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".

[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)