Obtain all the issues from epics from different projects.

Alejandro Acevedo March 14, 2024

Hello, in our area we have different projects where we have some epics which are on charge of a specific team. I need a query to obtain all the issues related to these epics and my advances are the next: 

* I create a Project Category to identify our projects from other areas. From there, I can find what epics are assigned to a specific team. 

category in ("Area 1") AND issuetype = "Epic" AND "Team[Team]" = 1

* I found that parentEpic() can obtain all the issues related to specific Epics. So, with the previous filter I can obtain the epics and close my current need.

The problem that I face is when a new Epic is created. I need to add the epic to the parentEpic list, that is why I am trying to mix both solutions. Do you have any idea about how I can solve this?

I tried something like this, but it is not supported by Jira:

parentEpic in (category in ("Area 1") AND issuetype = "Epic" AND "Team[Team]" = 1)

I found other alternatives but I face some problems:

* category in ("Area 1") AND  "Team[Team]" = 1 >> It requires that task and subtask are assigned to the Team, if it is avoided, the solution does not work. I tried the same with labels and components, but the result is the same.

* I understood that advanced apps for Jira can solve this situation, but we must pay for it :)

2 answers

1 vote
Mikael Sandberg
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
March 14, 2024

Default JQL can only use the parentEpic and you have to know the issue key for it. If you want to do a generic query like get all epics in a specific project and all children, then you would need an app from the Marketplace that either extends JQL, like JQL Tricks or Enhanced search. The other option is to use JXL, since it can return a similar result.

0 votes
Trudy Claspill
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
March 14, 2024

Hello @Alejandro Acevedo 

You said:

* category in ("Area 1") AND  "Team[Team]" = 1 >> It requires that task and subtask are assigned to the Team,

To ensure that tasks and subtasks are getting assigned to the same team as their parent you could use Automation Rules to copy the Team field from the parent Epic to the child issues and the subtasks.

https://support.atlassian.com/cloud-automation/docs/jira-cloud-automation/

Alejandro Acevedo March 15, 2024

Oh, thanks in advice, I will try it to see how it works.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
TAGS
AUG Leaders

Atlassian Community Events