How to add all issues belonging to Epics, on a certain board?

[Suzanne]

Hi All,

The solution is probably pretty simple, but I searched already an hour on the internet and the mentioned functions in some of the solutions did not seem to work for me.

So: I have created a board and added all epics with fixVersion='ABC'. 

Now I want all issues belonging to these epics also on the board.

I know I can add them with "Epic Link" in (AAA, BBB, CCC, etc.) but since it are a lot of epics, and new Epics can be added anytime, this doesn't seems the best solution to me. 

In the Structure application I did it like this:

- Insert issues: "FixVersion" = "ABC"
- Add issues belonging to epics

There must be a way to also do this in JQL?

In short: How can I add all issues from Epics with a certain fixVersion?

Thanks! 

[Walter Buggenhout]

Hi @Suzanne,

Since your starting point here is a fixVersion, I am assuming all your issues must be in the same project.

Why not reverse the logic and simply start by adding all the issues from your project to the board first:

Project = XX ORDER BY Rank 

And maybe add an additional quick filter to your board to filter out the issues assigned to those epics.

This way you can start with - maybe too many - issues on your board and then narrow down as you see fit?

[Suzanne]

Hi Walter, thanks for your reply.

The issues are not in the same project. They are across three projects. We created the same fixVersion in all three projects.

[Walter Buggenhout]

I was making that assumption as fixVersion is related to a project. So essentially you have 3 different fixVersions.

But the idea still remains the same - just update to:

Project IN (XX, YY, ZZ ORDER BY Rank)

Do you think it could work that way?

[Suzanne]

I don't really think that is a good solution. Then we would probably have over 5000 issues in the board, where I would only need the 100+ with certain Epics :-)

Regarding your remark "And maybe add an additional quick filter to your board to filter out the issues assigned to those epics": this would be the same as "Epic Link" in (AAA, BBB, CCC, etc.) right? Then everytime a new Epic is added I would need to adjust the JQL which is not very convenient.

[Walter Buggenhout]

I see what you are trying to do and why. Unfortunately there is no JQL option available to find the list of stories associated with a dynamic set of Epics. That's why I was trying to validate if there is no workaround.

I was more thinking about quick filters based on fixVersion:

> fixVersion IS EMPTY
> fixVersion = ABC
> fixVersion in unreleasedVersions()
> fixVersion in releasedVersions()
> fixVersion in latestReleasedVersion()

These 5.000 issues you have are not all open issues, right? If they are, then you will need to find  some way to label or identify issues that are ready for your board indeed (e.g. by automatically setting the fixVersion to the stories of an epic when you set the latter).

If they are not, then use the (kanban) backlog of your board to separate the backlog items from the work that is actually being worked on. And use the board filter or the release process to remove completed issues from your board regularly. In most cases I've seen, that should make things manageable.

[Suzanne]

Thanks for your reply, again. They indeed are not all open. Our Jira structure can be improved a lot. I will for now stick to "Epic Link" in (AAA, BBB, CCC, etc.).