Dynamically show all the stories (regardless of their project) of my epics in my board

[ibokettee]

So I have a project, say A, which has epics AE1, AE2, AE3.

I then have stories in other projects, say B & C which have stories BS1, BS2, CS1, and CS2.

BS1, BS2, CS1, and CS2 all belong to AE1 epic.

Now on my project A board, I want the four stories to show, as well as other stories in other projects that have epics in Project A.

Now I know how to modify the filter query if it was just one epic: project = A OR "Epic Link" = AE1

But how can I do this dynamically such that whenever I add a new epic i don't need to go back to edit the filter query to include the new epic? Basically how can i write the query to accommodate any other story that I will create in the future who has an epic in my current project

[mauricio.groth]

Hi @ibokettee 

I’m Maurício, a support engineer at Appfire and I’m here to help you.

Unfortunately, using JQL of Jira, you’ll not be able to do it dynamically.

In the app where my team works, JQL Search Extensions for Jira, you can use this query to find all your stories from any project that are children from epics of project A.

issue in childrenOfEpicsInQuery("project = a") and type = Story

Please contact our support if you have any other questions about this query.

We’ll be happy to help you!
Best regards,
Maurício

[Evgenii]

Hi, @ibokettee 

It's not an easy task without additional plugin, like ScriptRunner (with advanced JQL functions). 

Built-in JQL functions doesn't allow subqueries, like "show me all tasks, where epic in (list of epics in project A)". With built-in you can use only "parentEpic = AE1 OR parentEpic = AE2..."

[ibokettee]

Ouch! okay thanks. Was wondering if there was a way I could say "parentEpic" in current project or something like that, but I doubt...right?

[Evgenii]

Yes, it's a pity, but not with built-in JQL (

I used very ugly workaround for similar task - I created scheduled automation rule, which looked for epics in project, then looked for issues in epics, and then assigned label, like "issueInEpic". 
And then I made simple JQL, like label in ("issueInEpic"). It showed me all required tasks.

But it's very bad solution, it's better to use additiona plugins, which add advanced JQL functions.