Advanced Report Based on Blocked Issues

Patrick Dufresne October 11, 2017

I have a project management project where I'm trying to run a report on all items that are currently not being blocked by other tasks.

Is there a way I can search for this in a report?

Thanks


Patrick

1 answer

0 votes
Mikael Sandberg
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
October 11, 2017

You need something like ScriptRunner or JQL Tricks to do nested JQL queries. We have both apps, but I have only used JQL Tricks for advanced queries. In your case a query would look something like this in JQL Tricks:

project = X AND issue not in linkedIssuesInQuery("project = X AND issue in hasLinks(\"is blocked by\"),"is blocked by")

 You can create a similar query using ScriptRunner.

Patrick Dufresne October 11, 2017

Thanks, I would think there's a way to do it without an add on though no? I guess that's where I get creative with triggers and workflows..

Suggest an answer

Log in or Sign up to answer