Automated query to find all issues related to specific EPIC's

[Fabian B.]

Hi there, I am configuring our Team's Jira Kanban Board. We use Epics, Tasks, Stories and Sub-Tasks. Epics we use to cluster our company field activities (lets call them Business Units).

Now every Business Unit has it's specific Sub-Units. An Epic is a Sub-Unit (eg. SU-001)

My Goal: I want to configure quick-filters on the Kanban Board in order to only show issues (Tasks, Stories) related to a specific Business-Unit. So far, the Sub-Units (SU) have no link to the Business-Unit (BU), except the title of the Issue.

For my current query I used "Epic Link" IN (SU-001, SU-002, SU-003 ... ) because I know, which epic belongs to which Business-Unit.

However, this is a static query. If there are new Epics (Sub-Units) I have to manually change the filter, which is not desired. Thus, we have multiple boards, using the same filters.

Now I would like to automate this query, for instance by adding a data-field (lets call it Datafield BU) in the Epic (eg. SU-001) to say: Epic SU-001 belongs to Business-Unit A (lets call it BU-A), for example.

The JQL would be something like: "Filter all issues, with Datafield BU = BU-A in issuetype = Epic"

Do you have any suggestions? Does this work without additional plugins such as JQL Search Extensions for Jira? We are currently not in the cloud yet, but will move next year I believe.

If there is an alternative, easier way, let me know :).

Big Thanks in advance! Br, Fabian

[Sayed Bares [ServiceRocket]]

@Fabian B. I would suggest adding a Business unit customfield (Single select type) for your epics and then do the query based on that field.

So lets say if Epic 1,2,3,4, and 5 belongs to Business unit 1 then you will just need to update the business unit customfield to 1.

This way your JQL will be more dynamic.

Hope it helps!

[Fabian B.]

hey thanks, that is what I am up to, but do you know how the JQL query would need to be set up in that case? And if that solution will work with the standard version (without extra plugins)?