JQL - Check if issuetype "RfC" has a linked issuetype: Test (Zephyr)

Question

I would like to create a result list with JQL with following conditions:

Show all issuetype "RfC - equest for change" which NOT have a linked to a issuetyp "Test (Zephyr)

Something likethis

issuetype = "RfC Request for Change" and status not closed and is NOT (linked issuetype "Test")

Roger_mko8im · Answer

Hello Daniel

Thanks helping me.

a) Jira Server

b) not extending apps (as far as i know)

To bad thanks.

Daniel Ebers · Answer

Hi @Roger

two questions:

1.) is this a Jira Cloud or a Jira Server instance?
2.) do you have any scripting/JQL extending Apps available?

I know using ScriptRunner on Jira Server you can use the following query:

issuetype = "RfC Request for Change" AND status not in (closed) AND issueFunction in hasLinks() AND issueFunction NOT in hasLinkType(Blocked)

Now I see you asked for a check of the linked issue type, but good news: this is also possible:

issuetype = "RfC Request for Change" AND status not in (closed) AND issueFunction in hasLinks() AND issueFunction NOT in linkedIssuesOf("issuetype = Test")

In case you have no such App available with that capabilities, I am afraid that I do not know a way to do it "out of the box".
For suitable Apps there may be several available from Marketplace, however I am only familiar with the one mentioned above.

Regards,
Daniel

Roger_mko8im · Answer

I saw this article which is similar to my issue but i can not create scripts only use JQL

https://community.atlassian.com/t5/Answers-Developer-Questions/get-a-list-of-linked-specific-quot-Issue-Types-quot/qaq-p/513410