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

[Abhinav Choudhary]

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]

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.

[Tanya L Christensen]

Have you tried visualizing the blocked issues via Roadmaps or Advanced Roadmaps? 

https://www.atlassian.com/software/jira/guides/roadmaps/advanced-roadmaps

https://confluence.atlassian.com/advancedroadmapscloud/managing-dependencies-998651262.html

[Abhinav Choudhary]

Hi Tanya,

Thanks for your reply.

These still don't solve my problem of getting an export with all dependencies.

[Anusha.S Muralikrishnan]

Since you got partial result i would assume that the story is blocked by a story in some other jira project which only means adding that project key and the corresponding status types in the query as well

eg: project in ("Project 1", "Project 2") and issuetype in (Story, bug) and issueLinkType in("is Blocked by", blocks) and status not in (Done, Cancelled, Accepted) // all the bold highlights are from Project 2 in my example

in the above case my story is Project 1 is blocked by another story in Project 1 and a story in Project 2 = All three stories were listed in the resultant section.  

[Abhinav Choudhary]

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.

[Anusha.S Muralikrishnan]

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?