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

How to fetch the epics which are related to a list of Program epics matching certain criteria?

Abhijit Kulkarni_mm2bil

Project = "Proj-XYZ" AND labels = "Label-XYZ" AND issuetype = Epic AND "Parent Link" in (<subquery to generate a Program Epic list with a criteria that label is <some label>>)

So I need to have the epics which are related to different Program Epics matching certain criteria.

I hope I have clarified.

Would greatly appreciate if someone can assist in resolving this.

Thanks in anticipation.

Regards,

Abhijit

Accepted answers

Benjamin_tmh9yg

Hi @Abhijit Kulkarni ,

There various ways to achieve this. If all the Epics has a certain label, then you can just query as

issuetype=Epic and label = blah

I would see what the commonality between the them to pull the list. If it's a certain label, then use that. If it's a certain value for a custom field, then use that as well.

Hope this helps.

-Ben

Bill Sheboy

Hi @Abhijit Kulkarni

JQL is not a SQL, so you cannot do that type of sub-query with out-of-the-box JQL. You would need a marketplace addon app.

If you just need this once/a few times, you could export the issues and manually perform the join in a spreadsheet.

Best regards,
Bill

All comments

Benjamin_tmh9yg

Hi @Abhijit Kulkarni ,

There various ways to achieve this. If all the Epics has a certain label, then you can just query as

issuetype=Epic and label = blah

I would see what the commonality between the them to pull the list. If it's a certain label, then use that. If it's a certain value for a custom field, then use that as well.

Hope this helps.

-Ben

Abhijit Kulkarni_mm2bil

Thanks Ben.

But Probably i could have been more specific. But what kind of subquery I can include to get the Parent List (program Epics) that satisfy the criteria.

Let me modify that query to explain what I am trying to do

Project = "Proj-XYZ" AND labels = "Label-XYZ" AND issuetype = Epic AND "Parent Link" in (issuetype = 'Program epic' and labels='Label_Abc')

it gives an error:

"Error in the JQL Query: Expecting ',' or ')' but got '='. (line 1, character 100)"

I really intend to fetch all the epics which belong to a dynamically fetched list of Program epics

Would greatly appreciate if you can kindly help

Bill Sheboy

Hi @Abhijit Kulkarni

JQL is not a SQL, so you cannot do that type of sub-query with out-of-the-box JQL. You would need a marketplace addon app.

If you just need this once/a few times, you could export the issues and manually perform the join in a spreadsheet.

Best regards,
Bill

Abhijit Kulkarni_mm2bil

Thank you so much @Bill Sheboy . Appreciate your inputs. Probably addon is something I need to buy or may be change the way the epics/Program epics are being labelled so that those can be fetched using easy queries

Thanks again. It was very helpful.

Much appreciated.

Daniel Turczanski - JQL Search Extensions

Hi @Abhijit Kulkarni ,

With standard JQL you can only get a list of issues with links and export them to Excel for further processing. This works if you want to do a one-off analysis.

Standard JQL doesn't easily allow it but the results can be quickly found using our professional indexing service:

JQL Search Extensions

After you install the app you can simply search:
issue in parentsOfIssuesInQuery("Project = 'Proj-XYZ' AND labels = 'Label-XYZ' AND issuetype = Epic") and labels="some_label"

Make sure to check out the documentation.

I hope this helps!
Daniel

Welcome!

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

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud