Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,293,285
Community Members
 
Community Events
165
Community Groups

JQL to get issues with No Linked issues

JQL, to get the issues of a project for which Links is Empty OR  they are not linked to any other issues.

5 answers

I just discovered something like this:

project = xxxx AND issueLinkType not in (tests)

This way you can search for specific relations. the parameter is EMPTY does not work in my version.

 

Greetings

 

Jürgen

Hi Mahesh,

Apart from the bug which mentioned on previous comments, you can use JQL below if you have "Script Runner for Jira" plugin on your instance;

issueFunction not in hasLinks()

Best Regards,
Burak

Hi @Rag,

I tested "issueLinkType is EMPTY" and I can see Subtask are being included in the result.

If you would like to exclude Subtask from the result, you can use the following JQL:

issueLinkType is EMPTY and issuetype not in subtaskIssueTypes()

If you are still getting results that include linked issues, please provide some samples for troubleshooting.

Hi @mogavenasan 

I tried the same JQL as you mentioned above.

But here the Linked issues are not subtasks,  there are linked to other projects in the same instance.Linked 3.png

After using the JQL, we can see the linked issues in the Links Column.

Please have a look of the screenshot,  my idea is to get tickets of project "A" for which they are not linked to issues in any other project B, C, D  of the same instance

Hi @Rag,

I just did some reading on "issueLinkType" - it looks like it's quite buggy. You will need to use the workaround from JRACLOUD-73640.

I'm experiencing the same behaviour as you as well. I am able to reproduce it. 

0 votes

You can use the below query:

project = <Project_name> AND issueLinkType is EMPTY

Tried the above JQL but still i am getting the Linked issues,  the column Links is still showing issues linked to iBitt 2.png

Tried the above JQL but still i am getting the Linked issues,  the column Links is still showing issues linked to iBitt 2.png

Suggest an answer

Log in or Sign up to answer
TAGS

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