[JQL] How to exclude specific link issue (issuetype)?

[RIZKY JTUASIKAL]

How can I exclude certain issue types using JQL?

Example
issuetype = ‘Release Infra/Net/Security’ AND project = BTPNCORE AND status changed to COMPLETED during (2023-09-01,2024-12-31) and (Linkissuetype = ‘relates to’ and excludeissuetype = (issuetype A)) 

something like that (?)


I'm using Jira Cloud Standard

[Anshul Arora · Accepted solution]

Hi Rizky,

Say you are looking for linktype 'relates to' and want to exclude 'Task' issue type in a project BTPNCORE. You can try this. 

project = BTPNCORE AND issueLinkType = "relates to" AND issuetype != Task

Hope this helps.

Thanks,
Anshul

[RIZKY JTUASIKAL]

Hi @Anshul Arora ,

Thank you for answering my question.
I would like to ask again.

First, 
I have issuetype A, B, C, and D

The question is, 

How can I get issuetype A, which has no linkissue (relates to) to issuetype B (yellow mark on the picture)?

and if issuetype A has a linkissue to issuetype other than A (issuetype C and D), then it's okay.



Is this possible with jira standard?

[Anshul Arora]

Hi Rizky,

Thanks for the clarification. Unfortunately, JQL doesn’t support negative issue link conditions natively. You can't directly reference the issue type of linked issues in a simple JQL statement.

If you have ScriptRunner, you can try using the issueFunction to achieve this or any other marketplace plugin.

[RIZKY JTUASIKAL]

Hi @Anshul Arora ,

once again, thank you for the answer :)