How do I create a JQL/Dashbo in JIRA Cloud to get list of issues which are blocked by other issues?

Question

So i wanted to create a export or dashboard or filter in JIRA clod from where i can get list of issues which are blocked by other issues. I tried creating a JQL but it only gives us a status of main issues but not linked issues.

project in ("Test 2") and issuetype in (Story,"Testing Bug","Staging Bug") and issueLinkType in( "is Blocked by",blocks) and status not in (Done,"Known Issue",closed,"Pending Deployment")

Kindly help me in either creating a dashboard/JQL/Filter?

Rahul_RVS · Answer

Hi @Abhinav Choudhary

If you would be interested in a marketplace app, you can try out our add-on

Agile Tools - Epic Tree, Links Tree and Time in Status

You can view the full Jira Issue Type hierarchy of Linked issues, Portfolio/Advanced Roadmaps, Epics, and Subtasks up to 10 levels.

Key features :

* Hierarchy upto 10 levels deep
* Progress % on "remaining estimate" or "original estimates"
* Edit Issue summary, time estimates, story points and assignee on the tree with real time updates in the progress
* Rolled up percentage completion at all levels
* Ability to add/remove the columns on the report
* CSV export

Along with this there are multiple other features like Time in Status, Worklogs reports etc which the app provides.

Anusha.S Muralikrishnan · Answer

How about the project key of all your " Story,"Testing Bug","Staging Bug")  " ? same project or different ones? because ideally i am able to see all the columns i have pulled in populated. Does it sit in a different status name in a workflow? Maybe be that needs to be pulled in too?

Abhinav Choudhary_qrdnh3 · Answer

Hi Murali,

Thanks for the reply!

The status we have are all same, but have different workflows and also I want status of both the actual story and isblocked by story as well. So ideally I should know what's the status of the actual ticket and the ones blocking.