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 - Epics associated with set of Stories

Kelley Cooper

Is there any way, without Script Runner, to return a list of all Stories meeting certain criteria AND their associated Epics?

For example, I want to return all the Epics associated with Stories where Team = X. This seems so simple, but yet I can't seem to figure it out! There has to be some way to do this, else you have to use a common element on both Epics and Stories in order to populate an agile board with both Epics and Stories.

If it's not possible without Script Runner, then how do I achieve this with Script Runner?

Accepted answers

Steven F Behnke

Sorry: This is not possible out of the box. It's quite annoying, but it's true. There is a long standing improvement requests that I think you'll find interesting:

https://jira.atlassian.com/browse/JRASERVER-25640

To sum the current state of affairs: Out-of-the-box you can only search issues links one depth down, and can filter by type, with "linkedIssues()" jql function. Please see the documentation:

https://confluence.atlassian.com/jiracorecloud/advanced-searching-functions-reference-765593719.html#Advancedsearching-functionsreference-linkedIssueslinkedIssues()

It should be noted that Atlassian recently resolved JRACLOUD-59181, however it's Server counterpart hasn't been released yet. This means that there is an additional function in Jira Cloud: "parentEpic()", which additionally returns subtasks under the issues returned by the epic-story link type. "linkedIssues()" incorporates this functionality.

Now, ScriptRunner is not neccessary per-say: It's simply commonly used and a by-product of the power of that plugin is functions like the ones you see suggested elsewhere. There are plenty of plugins that allow for the ability to search by link type, and you can trial them all for free.

As far as ScriptRunner goes, the documentation you're looking for is here: https://scriptrunner.adaptavist.com/latest/jira/jql-functions.html#_linkedissuesof

All comments

Steven F Behnke

Sorry: This is not possible out of the box. It's quite annoying, but it's true. There is a long standing improvement requests that I think you'll find interesting:

https://jira.atlassian.com/browse/JRASERVER-25640

To sum the current state of affairs: Out-of-the-box you can only search issues links one depth down, and can filter by type, with "linkedIssues()" jql function. Please see the documentation:

https://confluence.atlassian.com/jiracorecloud/advanced-searching-functions-reference-765593719.html#Advancedsearching-functionsreference-linkedIssueslinkedIssues()

As far as ScriptRunner goes, the documentation you're looking for is here: https://scriptrunner.adaptavist.com/latest/jira/jql-functions.html#_linkedissuesof

Steven F Behnke

duplicate

Steven F Behnke

duplicate

Domenico Manzo _Actonic_

You could all stories involved in Epics (it is built-in JQL of ScriptRunner):

issueFunction in issuesInEpics("filter=EpicsList")

Kelley Cooper

Thanks, Steven.

So how am I supposed to create a filter which populates a board with both Epics and Stories/work items? Up to now we have used

project = <Project name> ORDER BY Rank

which retrieves everything, then we use Quick Filters to filter the work items by scrum team. But our boards are starting to return 1000s of issues and become non-performant. We couldn't be the only ones facing this issue...

The only way we can determine to populate a board with both Epics and work items is for both types of the items to have something in common...which is counterproductive. I just can't bring myself to believe that I can't use a board effectively unless I purchase and $$$ plugin.

Kelley Cooper

Yes...but I want to return a list of Stories (a subquery) AND all the Epics associated with those Stories.

The JQL you list only returns the Stories...I don't get any Epics.

Steven F Behnke

Foremost: If you have 1000s of issues in your product backlog, this is a problem. A product backlog typically has 100-400 tickets, 1000s is beyond the scale of an Agile Team, which a board is supposed to represent.

I ran into this problem with an Aerospace customer: They wanted to use Agile Boards for Hardware Tracking: The boards were not performant at 1000 issues much less 5k they were trying to use.

The fact is that they are using the tool WAY outside the intended use-case, so it's no surprise it doesn't work. It sounds like you're in the same boat: Agile teams DO NOT HAVE 1000s of issues in their product backlog. It's wrong. You can't use the board effectively because you're scaling it wrong. From my expert perspective, this is working as intended.

Secondly, you can't do what you want out of the box. You should buy a plugin. I can hardly see how JQLTricks is $$$: It's affordable and the price scales well for license sizing. Are you telling me that a $500 or $1000 purchase won't work for you?

Finally, the fact is that this product was made for certain use-cases: When you step out side those use-cases (agile development, in this case), then you can't possibly expect the product to just 'work' for you. Jira is extraordinarily flexibly but that doesn't mean you can throw a bunch of shit at it and expect it to work perfectly. Either use Agile Boards for Agile Development or seek alternatives.

Steven F Behnke

If you tell me whether or not you're on Server or Cloud, and what license size you have, I can recommend an affordable plugin.

Prem Chudzinski _extensi_

Hi @Kelley Cooper,

we've implemented the feature you were looking for

now you can filter out stories where Team is X and see all related epics directly on the backlog

more details http://go.extensi.io/nl2/6phl/18h93.html

Hung Nguyen_dioizn

Today, WITH scriptrunner, this can be done by the jql

issueFunction in epicsOf('Team = X'))

Welcome!

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

Quick Links

Find more posts tagged with

jira

jira-software