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

Robb F Watkins

We have ART level Jira projects (with only Epic issue types) and team level Jira projects (with Story level issue types)

Team #1 Wants to see all of their features and stories (This is not a problem) BUT - they would also like to see all of the stories (from other jira projects) also in those epics/features. Can anyone assist with the JQL for that? JQL Logic help.jpg

Accepted answers

Trudy P Claspill

Hello @Robb F Watkins

Native JQL functionality is not capable of getting you the results you want. It would need to do something like this:

Filter 1: The stories from ODP that have a parent Epic in ART

Filter 2: All the children of Epics identified by Filter 1

example:

issue in childrenOf( parentEpicsOf(project=ODF) and project=ART)

This can be supported only with the help of third party apps that extend JQL capabilities. Some of the apps listed here include the required functionality. Do you have any of these apps on your Jira instance?

All comments

Trudy P Claspill

Hello @Robb F Watkins

Native JQL functionality is not capable of getting you the results you want. It would need to do something like this:

Filter 1: The stories from ODP that have a parent Epic in ART

Filter 2: All the children of Epics identified by Filter 1

example:

issue in childrenOf( parentEpicsOf(project=ODF) and project=ART)

Danut M _StonikByte_

Hi @Robb F Watkins,

I'm afraid that this cannot be done at the JQL level.

But this might work by using the Work Breakdown Structure gadget offered by our Great Gadgets app. This gadget display the issues from a filter in a tree structure, in form of Initiative > Epic > Stories > Subtasks, along with their status.

Work Breakdown Structure (WBS) Gadget

Have a Jira filter that includes all the epics and stories from your ART and configure the gadget to use it. It will do the grouping for you. You could then refine the data, by creating a filter for each team.

This app offers many other gadgets that might be useful for your SAFe implementation. Take a look over this article from our blog: How to track multi-team or scaled-agile projects (such as SAFe®) in Jira with Great Gadgets app

I hope this helps.

Danut M.

Robb F Watkins

Yes - I have script runner advanced search

Trudy P Claspill

Then you should be able to construct this query in Enhanced Search to get the Epics of the issues in the ODF project where the Epics exist in the ART project.

issueFunction in epicsOf("project=ODF") and project=ART

Save that filter.

Then construct a second filter to retrieve the child issues of the Epics from the first filter:

issueFunction in issuesInEpics("filter = 'name of first saved filter' ")

However I have just tried using the issuesInEpics function in my own system and it is not currently returning any results. I have posted my own Question to ask if others are also experiencing that.

https://community.atlassian.com/t5/Jira-Software-questions/Scriptrunner-issuesInEpics-returns-no-results/qaq-p/2441179

There have been some changes being rolled out that will eventually deprecate the use of Epic Link, which the Scriptrunner function may depend on, but the Epic Link data does still seem to be present.

Try the above for yourself and let us know if you get results for the second filter.

Robb F Watkins

I get the same results for

issueFunction in issuesInEpics("filter = 'name of first saved filter' ")

It does not like issues in epics - But the first filter is working fine

Welcome!

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

Quick Links

Find more posts tagged with

jira

cloud

jira-software

jira-software-cloud