How to filter: stories where the epic has a certain custom field value

[Monica Turiac]

Hello, I need a filter where I select all epics + their stories, where the epic has a certain custom field set to a certain value ("assignedTeam = ALPHA"). How can this be done?

Thanks!

[Ste Wright · Accepted solution]

Hi @Monica Turiac 

Natively, this isn't possible.

You need to be able to do a sub-query within your main query - to filter for which Epics' stories should be included. You'll need an app with more advanced JQL functions for this, such as ScriptRunner

Then you could do a search such as:

issuetype = Epic AND assignedTeam = ALPHA OR issueFunction in issuesInEpics("assignedTeam = ALPHA")

The part in bold is what ScriptRunner provides, it is looking for all issues within Epics where the Epic's assignedTeam field equals ALPHA.

Ste