How can we search (jql) for issues that contain certain field values for their respective epics?

[Matthew Korich]

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

[Nicolas Bourdages]

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.