JQL Query to find Linked Issues to Epic over a targert quarter

[Michael Soby]

I understand it is straight forward to create a query to find the linked issues to an Epic.  My challenge is that I want to build out an automated tool with a JQL Query that will find Epics with its linked Issues assigned to certain Engineering Teams over a defined Target Quarter. this is my query "Epic Link" is not EMPTY AND project in (KENG, CLOUD) AND "Target Quarter" in ("2020 Q2", "2020 Q3", "2020 Q4", "2021 Q1", "2021 Q2", "2021 Q3", "2021 Q4") order by "Engineering Team". the challenge is that the Target Quarter is assigned to the Epic therefore I am having issues of obtaining the data that would represent 

Epic linked to a target quarter and has linked issues assigned to an Engineering tEAM

[Jack Nolddor _Sweet Bananas_ · Accepted solution]

Hi Michael, Could you please clarify us a couple of things?

"Target Quarter" is an Epic field? or a Story field?
"Engineering Team" is an Epic field? or a Story field?

As per my understanding "Target Quarter" is at Epic level but "Engineering Team" is a Story field. So....

Sadly you cannot achieve the desired search using standard features on Jira, you must go for a third-party app instead. Using i.e. JQL Booster Pack if you are on Server / DataCenter, you can type the following:

1) Search all 2020 Q2 Epics

type = Epic AND "Target Quarter" = "2020 Q2"

2) Search for issues of a particular "Engineering Team" linked to 2020 Q2 Epics

"Engineering Team" = Team_1 AND issue IN issuesInEpics('  type = Epic AND "Target Quarter" = "2020 Q2" ')

3) All together <3

(type = Epic AND "Target Quarter" = "2020 Q2") OR ("Engineering Team" = Team_1 AND issue IN issuesInEpics(' type = Epic AND "Target Quarter" = "2020 Q2" '))

(*) Note that this is just an example, you must tune above query to fit your needs.

Using this app you can also query other issues relations, check:

• epicsOf()
• hasSubtasks()
• issuesInEpics()
• linkedIssuesOf()
• parentsOf()
• portfolioChildOf()
• portfolioParentOf()
• subtasksOf()

References:

• Official documentation

[Michael Soby]

"Target Quarter" is a field that is in both Epic and Story, it is only used in Epic
"Engineering Team" is a field that is in both Epic and Story, it is only used in both Epic and story to assign in the correct backlog

[Jack Nolddor _Sweet Bananas_]

So probably the above queries will work for you "as is"

[Michael Soby]

Thank you for the inputs.  There is no field issueInEpic so I modified the query to get what I needed

[Jack Nolddor _Sweet Bananas_]

issueInEpics is a jql function provided by JQL Booster Pack is not a native field.

Which JQL you finally used?