It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Issues in epic for a constrained list of epics

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?

1 answer

1 accepted

0 votes
Answer accepted

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)

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. 

Suggest an answer

Log in or Sign up to answer
TAGS

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you