Trying to create a dashboard to show blockers and blocking from 10 diff Jira projects in my function

[Gopal S]

I am working as  a project Manager, i have around 10 Jira projects in my function and my requirement is to show blocked status tickets team in rows and blocking tickets team in columns. So far am able to display either blocked or blocking teams and not the both. Hence expecting some solution in this forum. 

To get blocking issues:

issueFunction in linkedIssuesOf("filter = 'filter name'", "is blocked by") AND status not in (Closed, Resolved) ORDER BY created DESC

Blocked issues: 

project in ("a", "b", "c", "d", "e") AND status = Blocked

How to combine and display these two filters results? 

[Vishal]

Hi @Gopal S 

All you need to do is add "OR" operator in the two filters that you have managed to create. So, your query will look something like :

(project in ("a", "b", "c", "d", "e") AND status = Blocked) OR (issueFunction in linkedIssuesOf("filter = 'filter name'", "is blocked by") AND status not in (Closed, Resolved)) ORDER BY created DESC

Try this & let me know if it works.

[Gopal S]

Hi @Vishal Thanks for your suggestions, now am able to get the combined results from both the queries, but how do i display it in the dashboard or a board with the linkage between those two filter results? like blocked and blocked by views.

[Vishal]

Hi @Gopal S 

I assume you already have a dashboard created, if so just add linked issues in column display of gadget configuration, which should show linked issues, it should work, can't remember if it works in jira server haven't used since long.

Hope this helps.

[Gopal S]

Yes Vishal i have a Dashboard with Projects having blocked issues in the rows but to show linked issues in the columns, seems Jira Server doesn't support displaying linked issues :( . So i have to see any other workarounds to have that view.  Thanks.