Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

How to filter all issues that are not linked to another project?

I would like to have a filter that gives me all the Spikes and User-Stories in a current sprint that are not linked to another project. It's part of our Definition of Ready to link User-Stories to the Project "Features", so I would like to have an overview where this linking is missing. 

I tried it like this:

project = "SYST" and Sprint in openSprints () and issuetype in ("Spike", "User-Story") and issueLink != "FEAT-*" but unfortunately the wildcard * doesn't work here. 

Any ideas or tips? 

Thanks in advance :) 


4 answers

3 accepted

1 vote
Answer accepted

Hi @Simon Stafflinger ,

YOu can try with linkedissuesof function from scriptrunner plugin.

0 votes
Answer accepted
Muhammad Ramzan Community Leader Sep 07, 2019

You can use JQL Search Extensions for Jira & reports plugin  to get the required results, you you case you can use the query as below


following query will return all issues which are not linked with project "Test"

issue not in linkedByIssueProject("test")


or you can use following query and pass multiple projects


Find issues which link at least one issue from project test,test2. 

issue in links("project in (test,test2)")
0 votes
Answer accepted

Hi @Simon Stafflinger

How are the issues linked to a Feature? Is it "relates to" or a similar custom link type? And this links to an Issue Type of Feature? Is this linked via linked issues or Portfolio Parent Link?

Most linked issues search parameters work around either a specific issue or a link type - for example:

  • IssuesRelatesTo or...
  • issueLinkType in (XXX) - useful for custom link types like is parent of / is child of

^ If your Features have a specific link type then you could search for issues without them which should get you most of the way there.

When it comes to more advanced searching (for example, look for all issues with linkages not linking to Features) you do need to consider Apps such as ScriptRunner - but give us a little more information and happy to try and replicate!


Thanks for your helpful answers! :) Unfortunatley we can't buy more plug-ins at the moment, but it's good to know that the possibility would be there with this plug-ins. 

Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Jira

Do you use Jira Cloud with Microsoft Teams?

Hi, Jira users! Do you use Jira alongside Microsoft Teams? We want to hear how you’ve used the power of Jira Cloud and Microsoft Teams (via the Jira Cloud for Microsoft Teams app) to achieve a team...

41 views 0 3
Read article

Community Events

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

Find an event

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

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you