How to write JQL to show all Children Stories/Tasks of Epics that are "IN PROGRESS"

[Cole Swain]

We are looking to create a board that shows the following

- Each swim lane is an in progress epic

- Within each swim lane the respective stories/tasks for the epic are shown 

- Each column represents the status in the workflow of the stories/tasks

To do so, we will base the board off of an advanced query result. The issue is that we can't seem to filter for stories/tasks for EPICs that are in progress. In other words we want to query for 

project = PRODUCT AND issuetype in (Epic, Story) AND issueEpicStatus = "IN PROGRESS" order by created DESC

This of course fake query to convey the concept. But we can't seem to get data from the parent epic in the query of the issues. Does anybody have any suggestions here? The "EpicStatus" fields doesn't seem to work because it only works if you are querying for epics and not issues. 

[Trudy Claspill]

Do you have any third party apps that extend the JQL functionality, or are you open to getting such?

You cannot do what you want with native Jira functionality. You would need something like

(project=X and issuetype=Epic and EpicStatus="in Progress") or (project=x and "Epic Link" in ( (project=X and issuetype=Epic and EpicStatus="in Progress") )

An app that supports using sub-filters could assist with your query. Jira doesn't natively do that. Adaptavist Scriptrunner is one such app, but I know there are others. If you go to the marketplace and search for "jira jql extensions" that should give you options to investigate.

[Cole Swain]

Thank you Trudy!