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?

[Trudy Claspill · Accepted solution]

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?

[Robb F Watkins]

Yes - I have script runner advanced search

[Trudy 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

[Romy Greenfield]

Hello Robb, 

It sounds as though you are experiencing issues with our issuesInEpics function. I just did a quick spot check on a production instance and cannot reproduce that behaviour.

However, if you are using ScriptRunner for Jira Cloud you can raise a support request here and we can look into this further for you. Similarly if you are using Enhanced Search you can raise a support request here. 

Please let me know if you need any further help.

Best regards

Romy 

[Trudy Claspill]

Hello @Robb F Watkins 

In my ticket with Adaptavist they noticed that I have changed the name of the Epic issue type in my system. They said that was causing the failure of the function. When I changed the name of the Epic issue back to "Epic" the function did indeed work.

Have you renamed the Epic issue type in your system?

[Trudy Claspill]

Adaptavist has a change request, that is at least two years old, to support renamed Epic issue types. Add your vote!

https://scriptrunner-for-jira-cloud.nolt.io/22

[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. 

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.