JQL to get issues with No Linked issues

[Rag]

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

[Ollie Guan_携程]

Hi @Rag ,

issueLinkType is EMPTY

https://support.atlassian.com/jira-service-management-cloud/docs/advanced-search-reference-jql-fields/

[Rag]

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

[Deepanshu Natani]

You can use the below query:

project = <Project_name> AND issueLinkType is EMPTY

[Rag]

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

[mogavenasan]

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.

[Rag]

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.

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

[Rag]

https://jira.atlassian.com/browse/JRACLOUD-73640?error=login_required&error_description=Login+required&state=717321f4-80a8-4db2-896b-3966c992c508

[mogavenasan]

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. 

[Burak Kaya]

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