Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Celebration

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root

Avatar

1 badge earned

Collect

Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

Challenges
Coins

Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.

Recognition
Ribbon

Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

Leaderboard

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

Edited

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.
Sep 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.

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.
Sep 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.

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