Obtain all the issues from epics from different projects.

[Alejandro Acevedo]

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 :)

[Mikael Sandberg]

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.

[Trudy Claspill]

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]

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