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

Accepted answers

Jack Nolddor [Sweet Bananas]

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

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

References:

Official documentation

All comments

Jack Nolddor [Sweet Bananas]

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

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

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

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

Welcome!

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

Quick Links

Find more posts tagged with

cloud

jira-software

issue-link

epic