Possible to create a Kanban board with issues from certain epics?

[Michael Remijan]

Hi there,

I am using Jira 10.3.2. I want to get a Kanban board of issues where the issues are linked to epics matching certain criteria.  I'd need to be able to do this using JQL, not any add-ins because add-ins won't be available to me.  In pseudo query language, it would be something like:  

select issues where issue.epic in (select epic where epic.color = red and epic.status = open)

Of course, I know the above pseudo query is nonsense, but it gets the point across.

I don't know if I can do this exclusively with filter query or if I would need to use a filter with a combination of Kanban board configuration and/or sub-filter. Or if this is even possible at all.

This just seems to me like something extremely common which users would want to do. I'm just not seeing the way to do it. Any help would be appreciated.  

[Aaron Williams]

Hi @Michael Remijan 

It is possible to call "Epic colour" = red, in a JQL statement but you have to use the colour codes mentioned here: https://support.atlassian.com/jira/kb/use-epic-color-for-epics-in-jira-cloud/

Let me know if you need any more help on this. 

Thanks

Aaron. 

[Michael Remijan]

No, I'm sorry, but this does not help. It does not address what I'm asking about.

[Stefan Stadler]

Hi @Michael Remijan 

unfortunately, I doubt this will be possible without addons to be obtained in one query.

The problem is, that Jira does not ship with queries that can provide a list of issues based on a dynamic query list of issues.

I know that for example ScriptRunner (which is a very common addon) is capable of doing exactly this.

Without an addon, I think this will always be a two step approach:

1. Use the following JQL for getting a list of relevant Epics:

issuetype = Epic AND "Epic Color" = ghx-label-9 AND status = Open

ghx-label-9 means orange, which appears to be closest to red, but I might be mistaken.

2. create a comma separated list of issue keys from the above query and use it in the following one:

"Epic Link" IN (KEY-1,KEY-2,...)

In order to get a complete list of issues, you would also have to include the issue keys of the epics. Otherwise they will not be part of your board. So this would be your final query:

"Epic Link" IN (KEY-1,KEY-2,...) OR key IN (KEY-1,KEY-2,...)

Using addons you could get this done in one query, but without, this appears to be a closest solution I can imagine of.

Hope this still helps!

Stefan