How do I limit the status of only one issuetype in the results?

[Bradley Holbrook]

I want to create a query the will return all stories (regardless of status) and epic (if in progress) where the stories only belong to the epics returned.

[Mikael Sandberg]

JQL does not allow you do nested queries, like get all stories belonging to epics in specific status. You need an app like ScriptRunner or JQL Tricks, and there are other ones that can do it too.

[Mikael Sandberg]

If you use JQL Tricks the query would look like this:

issue in issuesWhereEpicIn("status = \"In Progress\"")

[Bradley Holbrook]

This is as close I could get:

type = Epic AND status = "In Progress" OR type = Story

[Carlos Faddul]

Currently we do not use the concept of epic and stories, however I believe the JQL query would be, something like this:

"Story Points" = 1 AND "Epic Status" = "In Progress"

Change de "Story Points" to another issuetype.

[Bradley Holbrook]

Thanks! This wasn't it - but it got me to the right spot.