Issues in epic for a constrained list of epics

[Andrew Butters]

I have a query that will return a list of Defects, Tasks, and Stories in a specific project that have specific statuses that are linked to a list of Epics:

issueFunction in issuesInEpics("key in (IEI-100149, IEI-75694, IEI-93612, IEI-93755, IEI-64800, IEI-84670, IEI-103089, IEI-67785, IEI-13856,IEI-103693)") AND type in (story, task, defect) AND project = iei AND status not in (closed, done, rejected, deferred)

What I need is a way to do this without hardcoding the list of Epics. It would look something like this: 

issueFunction in issuesInEpics("key in (Type=Epic and fixVersion in (ver1, ver2))") AND type in (story, task, defect) AND project = iei AND status not in (closed, done, rejected, deferred)

Only that doesn't work and I haven't been able to figure out how to do it. Anyone have thoughts?

[Dar Kronenblum · Accepted solution]

Hi @Andrew Butters ,

try to remove the 'key in' pare, something like this:

issueFunction in issuesInEpics('Type=Epic and fixVersion in (ver1, ver2)') AND type in (story, task, defect) AND project = iei AND status not in (closed, done, rejected, deferred)

[Andrew Butters]

Hot dog, we have a wiener! 

The only thing that doesn't work, and I didn't ask this in my original question, is using a rich filter. It filters the results on fixversion, but if I leave the fixversion out of the constraint within the "issuesInEpics" function it only filters on the stories, tasks, and defects for the fixversions selected and not the Epics in the function (because there can be tasks and such in one fixversion even if the epic is in another). Not a big deal, but if there's anyway to do that it would be perfection.