nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

JQL to get bugs linked to stories linked to an epic ;)

Doug Varn1

Is there a way to do this? I want a filter that gets me the Bugs linked to all the Stories linked to a certain Epic.

Accepted answers

Udo Brand

You can combine those in following way:

1. create a filter that shows the stories linked to your epic (filter1)

issueFunction in linkedIssuesOf("issue = SMC-242", "is Epic of") and issuetype = Story

2. create a second filter that uses filter1:

issuetype=Bug AND status != Done AND issueFunction in linkedIssuesOf("filter = filter1", "<YourLinkType>")

All comments

Doug Varn1

This gives me the issues (all types, not just Stories) linked to a particular epic:

issueFunction in linkedIssuesOf("issue = SMC-226", "is Epic of")

But how to now get a list of bugs linked to all those...

JamieA

There was a question on this recently, but I can't find it. You need to the nest the query. Maybe try from the perspective of the bug, and use the filter query to find stories then epics. This is certainly possible.

Doug Varn1

Ok, maybe I'll find it. I haven't nested queries before, so maybe that's partly my problem.

I can get all bugs linked to a story with:

issuetype=Bug AND status != Done AND issue IN (linkedIssues("SMC-390"))

And get all stories linked to an epic with:

issueFunction in linkedIssuesOf("issue = SMC-242", "is Epic of") and issuetype = Story

But I can't seem to combine the two.

Udo Brand

You can combine those in following way:

1. create a filter that shows the stories linked to your epic (filter1)

issueFunction in linkedIssuesOf("issue = SMC-242", "is Epic of") and issuetype = Story

2. create a second filter that uses filter1:

issuetype=Bug AND status != Done AND issueFunction in linkedIssuesOf("filter = filter1", "<YourLinkType>")

Doug Varn1

Thanks for the tip. Sadly, linkedIssuesOf requires the second param, and my QA people have used different link types at random, so it's not going to be practical for me to look up the bugs this way without having them clean things up first.

Wish it could find by any old link type!

Jose M_

It is definetily not easy to perform a filter covering all needs. I am looking for an easy way to find all Epics, Stories and other issue types, inclusive their sub-tasks.

The following helps a little:

"Epic Link" = ... OR "Epic Link" = ... OR parent in (..., ..., ..., ...) ORDER BY "Epic Name" ASC

Vijay Khacharia

Hi,

This plugin provides the possiblity to search the issues by links of all types. It is paid though not so expensive.

https://marketplace.atlassian.com/plugins/org.craftforge.jira.craftforge-jql-functions-plugin

I have used both the plugins, only advantage I see with Craftware plugin is the need of getting parent issues of all the linked tasks.

Vijay.

JamieA

The next version won't require the second param, in which case it means: work across all link types

Udo Brand

Ah, that are good news. Thanks Jamie!

JamieA

I wrote up how to write queries like this: https://jamieechlin.atlassian.net/wiki/display/GRV/Scripted+JQL+Functions#ScriptedJQLFunctions-MoreComplexExamples

Hope it helps someone.

Emna BEN BRAHIM

Hello ,

Probably this could Help:

issue in linkedIssues(parentid, parent-of)

in the parent id just put the id of the epic . it will bring all the issues that are under the given epic id

then filter on issuetype bug.

thanks,

Emna

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

jql

epic

sub-task

story