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

[Abhijit Kulkarni]

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

[Bill Sheboy · Accepted solution]

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]

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.

[Benjamin · Accepted solution]

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]

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

[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