How can you filter out blocked issues in the dashboard?

Baruch Lerner November 14, 2021

I am trying to filter out the blocked issues from the different filters in my dashboard.

According to what I understand it should be:

 issuelinktype not in ("is blocked by") 

for some reason, it doesn't show anything for me.

 

The full formula I'm using:

project in (IT, "DO", DS, QA, "Apps / Websites") AND status in (New, Processing, Review) *AND Issuelinktype not in ("is blocked by")* AND (duedate <= -0d OR duedate = EMPTY) AND priority = High ORDER BY "DS Version" ASC, status DESC

4 answers

1 vote
Baruch Lerner November 29, 2021

Hey guys,

 

Thanks for all the help.

Eventually, the solution that worked was suggested by Prince N:

 

issueLinkType in ("is blocked by")

Save above as filter. Then search the filter as below

E.g.

filter not in (filter1)
0 votes
Daniel Turczanski - JQL Search Extensions
Atlassian Partner
November 26, 2021

Hi @Baruch Lerner

Make sure to include issues without the links as well:

... (Issuelinktype not in ("is blocked by") OR issuelinktype is empty) ...
0 votes
Curt Holley
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
November 14, 2021

Couple of things

  1.  Why the * characters? (I'd remove those)
  2. Do you need to add the other Blocked link type definition? i.e. Issuelinktype not in ("is blocked by", blocks)

Baruch Lerner November 24, 2021

but I don't want to see only the issues that are blocked..

If its an issue that blocks others I do want to see it...

0 votes
Sebastian Krzewiński
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
November 14, 2021

Hi @Baruch Lerner 

 

What is the result that you currently get? Did you check if issues that should be filtered out have more than one link inside?

 

Seba

Baruch Lerner November 24, 2021

The result I'm getting is - not finding any issues.

None of them have more then one link inside.

Curt Holley
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
November 24, 2021

Are you getting any errors, or just no results?

What JQL are you using now?

Baruch Lerner November 28, 2021

No error, just not results.

What do you mean by "What JQL"? on Jira Work Managment?

Curt Holley
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
November 28, 2021

I mean, are you still using this (exactly), or have you changed it?

The full formula I'm using:

project in (IT, "DO", DS, QA, "Apps / Websites") AND status in (New, Processing, Review) *AND Issuelinktype not in ("is blocked by")* AND (duedate <= -0d OR duedate = EMPTY) AND priority = High ORDER BY "DS Version" ASC, status DESC

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
PERMISSIONS LEVEL
Product Admin
TAGS
AUG Leaders

Atlassian Community Events