JQL QUERY TO FILTER OUT ALL THE LINKED ISSUES WITH STATUS OPEN AND IS LINKED TO ISSUE TYPE STORY

[Behl_ Aman]

we have link a lot of issues to our Story (= deliverables for us). The purpose is to follow if there is no more open issues related to deliverables.

For this I want to extract for a list of Jira Story, all the linked issues, with a certain linkType (ex: blocked by), with a certain status (ex : <> done)

1st idea : extract from excel the list (connect to Jira Api directly from excel) and after with a macro, get the linked defect. Unfortunately, basic auth does not work and I don't know how to get the SSO token

2nd idea : make an automation that changes Story status to "blocked" if there is any linked issues with a status <> done and with a link type = blocked by. Don't know if it's easily possible

3nd idea : use easyBi but don't have access and don't know if it's possible

[Zane eazyBI Support]

Hi @Behl_ Aman,

In eazyBI, you may import information on issue links and represent linked issues in a separate dimension (https://docs.eazybi.com/eazybijira/data-import/advanced-data-import-options/import-issue-links).

For example, you may import links from a defect perspective; a new dimension "Linked Deliverable". And then, in the report, you can show defects and linked Deliverables to them. You may also filter defects by priority, project, assignees, status, etc. (see picture below).

Best,
Zane / support@eazyBI.com

[Marco Brundel]

Hi, do you use Scriptrunner? With Scriptrunner you have the issuefunctions JQL function.

Example: 

issueFunction in linkedIssuesOf("status = Open", "blocks") and resolution is empty