How can you filter out blocked issues in the dashboard?

[Baruch Lerner]

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

[Baruch Lerner]

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)

[Daniel Turczanski - __JQL Search Extensions]

Hi @Baruch Lerner

Make sure to include issues without the links as well:

... (Issuelinktype not in ("is blocked by") OR issuelinktype is empty) ...

[Curt Holley]

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]

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

[Sebastian Krzewiński]

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]

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

None of them have more then one link inside.

[Curt Holley]

Are you getting any errors, or just no results?

What JQL are you using now?

[Baruch Lerner]

No error, just not results.

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

[Curt Holley]

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