What is the correct way to find items that do not include a specific link?

[Ron Feldman]

When I run this query I get 64 results, as expected:

project = PGE and issuetype = Story and "Epic Link" = PGE-1574 and Sprint = 182

When I run this query, which adds the issueLinkType clause, I get 0 results, though I was expecting 64 results.

project = PGE and issuetype = Story and "Epic Link" = PGE-1574 and Sprint = 182 and issueLinkType != "is blocked by"

This clause is taken from the JQL fields documentation.

[Trudy Claspill · Accepted solution]

Still researching, but I think this might be relevant.

https://jira.atlassian.com/browse/JRACLOUD-73640

[Trudy Claspill]

Also, do the child stories all have at least 1 issue linked to them?

If the child stories have no issues linked to them then you need to use this filter to include those in your output:

AND (issuelinktype != "is blocked by" or issuelinktype is empty)

[Ron Feldman]

Hey, adding "or issuelinktype is empty" resolved it!

Thanks very much!

[Bill Sheboy · Accepted solution]

Hi @Ron Feldman 

Would you please provide your complete JQL statement?  That may reveal more information about what is happening.  Thanks!

Best regards,

Bill

[Ron Feldman]

Thanks, I have updated my original post with the query that gives expected results and the query that gives unexpected results.