Advanced Report Based on Blocked Issues

[Patrick Dufresne]

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

[Mikael Sandberg]

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]

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