[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 :)

[cyrine belhadj]

Hello @RIZKY JTUASIKAL  , 

In jira native you can't create issue link with specific types 

As alternative you can try this solution : 
   Create a field for example name = "linked to type " 

   Then go to create an automation rule : 
       Pick Issue linked as Trigger and choose the type you want 'relates to ' for example 
       And for the condition make the fied issue type equal A
       Then in the action add value  A for the field linked to type  
After that you can use a JQL to filter 

And if you're open to other solutions you can use app to create linked issue based on types or either projects and one of these apps is Enhanced Links for Jira