Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Gopal S September 20, 2023

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? 

1 answer

0 votes
Vishal
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
September 20, 2023

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 September 20, 2023

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
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
September 20, 2023

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 September 21, 2023

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.

Suggest an answer

Log in or Sign up to answer