Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

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

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.

4 answers

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

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

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. 

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

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