Jira query for Bugs by epic and the epic is in progress

[Yolanda Repetto-Logan]

I need a query for to show the bugs that are associated to an epic, and the epic is not closed. 

I am able to render a list of all active bugs associated to an epic via the below query, but I need to filter further and show only those bugs associated to an "active" epic.

project in (xxx, xxx, xxx...) AND type = Bug AND status not in (closed) AND "Epic Link" is not EMPTY 

[Alex Christensen · Accepted solution]

There is also another JQL function from ScriptRunner that should allow you to do this. I think the basic queries you're looking for are:

All Bugs in Open Epics

issuetype = Bug and issueFunction in issuesInEpics("resolution = Unresolved")

 All Bugs in Closed Epics

issuetype = Bug and issueFunction in issuesInEpics("resolution != Unresolved")

[Thomas Deiler]

Dear @Yolanda Repetto-Logan,

before you use a sledge-hammer to crack a nut, try another plugin called JQL Search Extensions. The query will look like this:

issue in linkedBy("relates to", "project = XXX")

So long

Thomas

[Alexey Matveev]

Hello,

You could use the Power Scripts add-on:

https://marketplace.atlassian.com/apps/43318/power-scripts-jira-script-automation?hosting=cloud&tab=overview

Your JQL query would look like this

key in issueInEpics("status != \"In Progress\"")

[Mesut Yilmazyildirim]

If you have script runner plugin you can use issueFunction JQL command;

But;

Epic link is majorly used to link a story .

Query can be like this for a story:

issuefunction in linkedIssuesOf("project = XXX", "is Epic of")

Bugs can be linked to an epic with 'Relate' as well.

For 'Relate'  issue link , the outward and inward description is same 'Relates to' by default.