Filter in Subboard with stories and their tasks

[Gerd_Huhn]

Hi guys,

I've got a problem, which I can't solve and I don't know why :D

We have an Kanban Board and we created a subboard. The subboard should show all stories with a specific epic-link and their subtasks.

I only can show all the stories but without the subtasks. 

That's my filter: 

project = OEKM AND issuetype = Story AND Epic-Verknüpfung = OEKM-2

I've realized, that this specifically excludes the subtasks because the subtasks don't have an epic link, but I don't know an other way.

Any tips?? I'm sure, that this is no rocket science, but I'm stuck...

Greets

Gerd

[Jack Nolddor _Sweet Bananas_]

Hi Gerd,

Sadly you cannot achieve the desired search using standard features on Jira, you must go for a third-party app instead. Using i.e. JQL Booster Pack you can type the following:

Search for all issues and their subtasks under OEKM-2 Epic

Epic-Verknüpfung = OEKM-2 OR issue IN subtasksOf("Epic-Verknüpfung = OEKM-2")

Using this app you can also query other issues relations, check:

• epicsOf()
• hasSubtasks()
• issuesInEpics()
• linkedIssuesOf()
• parentsOf()
• portfolioChildOf()
• portfolioParentOf()
• subtasksOf()

References:

• Official documentation

Hope this helps you to create awesome queries <3

Kind regards

[Pete Singleton]

To filter sub-tasks based on the Epic link of the Story, you need an addon that will allow you to run sub-queries. ScriptRunner does this, or so will a few other advanced JQL addons.  Do you have ScriptRunner?

[Gerd_Huhn]

Thanks for your answer. 

No I don't have it, yet. Is it easy to install and handle? :D

[Pete Singleton]

Any addons for Jira are easy to install - however they are separately licensed.

[Pete Singleton]

Another addon which would do this is "Search Linked Issues" 

https://marketplace.atlassian.com/apps/31601/search-linked-issues

This would likely be cheaper for you than ScriptRunner.