Search for epics in a story where the story has a specific filter

[Abdulrahman Güngör]

I would like to find all epics with a version >= 5, but which have a specific story linked to them.
The linked story should have a certain filter.
E.g. Only stories with a certain label.

In text the filter should looks like:
Find all epics with the FixVersion greater than 5 that have a story linked where the story uses the label "MyLabel".

[Charlie Misonne · Accepted solution]

Hi Abdulrahman,

Welcome to the Atlassian Community!

You'll definitely need an app (plugin) to achieve that. With ScriptRunner it can be done with the Enhanced Search feature. You can execute this JQL:

type = epic and issueFunction in epicsOf("labels = MyLabel") and fixVersion > 5

The issueFunction in epicsOf("labels = MyLabel") is from the app.

You could try other smilar plugins like the ones below. Install a trial to validate whether they can do what you expect.

• JQL Tricks Plugin
• JQL Booster Pack
• JQL Search Extensions for Jira & reports

Here is the Marketplace to find similar apps: https://marketplace.atlassian.com/search?hosting=cloud&product=jira&query=jql

[Abdulrahman Güngör]

Thank you! Works great!