JQL for Blocked issues not having "Blocked By" linked issues

[Yatin Shingala]

I want the Jira issues which are having status Blocked.  But does not have any linked issue as "Blocked By" link.

How can I find such issues using JQL?

[Josué Garcia · Accepted solution]

Try something like:
status in ("Blocked") and issueLinkType not in ("Blocked By")

[Yatin Shingala]

This doesn't work.

These are the possible scenarios

1.  If issue is blocked and there is no linked "blocked by".  It show this issue.  It correct.

2. If issue is blocked and there is only link "blocked by".  It doesn't show this issue.  It is correct.

3. If issue is blocked and there is link "blocked by" and also another link e.g. "is parent of".  It show this issue.   I am expecting the issue should not display as there is a "blocked by" link exist.   I want the solution that cover this scenario.

Expected result is any issue having linktype "blocked by" should not be shown irrespective of it has other link exist or not....

[Kelly Arrey]

Hi @Yatin Shingala, don't ask me how I know this.

1. Save this as a filter - let's call it "has blocked by link":
   
   issueLinkType = "Blocked by"
   
   
2. Write the following filter which calls the above filter:
   
   status = Blocked AND (filter != "has blocked by link" OR issueLinkType is EMPTY)
   
   

See JRACLOUD-73640  for more info.

[Yatin Shingala]

Thanks @Kelly Arrey , 

It is working