For example. I want to create a pie chart of all issues that have an epic defined and whose "roadmap" value is "2016-Q2" and partition by epic-time-remaining. Highly useful but currently not supported AFAIK by JQL. I can search overall, but "by roadmap" seems impossible for now.
project = FOO AND "Epic Link" is not EMPTY AND resolution = Unresolved ORDER BY <blah> ASC
Should be
project = FOO AND "Epic Link" is not EMPTY AND "Epic Roadmap"="2016-Q2" AND resolution = Unresolved ORDER BY <blah> ASC
You need the advanced ScriptRunner JQL functions.
https://scriptrunner.adaptavist.com/latest/jira/jql-functions.html#_linkedissuesof
Your JQL should look something like this:
Project = FOO AND issueFunction in linkedIssuesOf("roadmap = 2016-Q2", "is Epic of")
Just buy the plugin and play with it. It's awesome.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.