Get all Issues without linked issue

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



2 answers

1 accepted

1 vote
Accepted answer
Tarun Sapra Community Champion Aug 24, 2017

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

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 Community Champion Aug 24, 2017

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

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?

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

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

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Jan 08, 2019 in Jira

How to Jira for designers

I’m a designer on the Jira team. For a long time, I’ve fielded questions from other designers about how they should be using Jira Software with their design team. I’ve also heard feedback from other ...

1,251 views 5 10
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you