Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

JQL query: how to get output of child ONLY JIRA stories of particular filter(EPICS)

John K December 1, 2022

Hi, the objective is to get an output list of all JIRA child stories from particular Epics.

Identified Epics (could be a filter) or all Epics that have a particular component field or label, etc...

 

 

 

1 answer

0 votes
Seifallah Bellassoued
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
December 1, 2022

Hello @John K

Welcome to the community!

The "Epic link" is a specific "Issue Link". You can use this JQL:

issueFunction in linkedIssuesOf("PUT A JQL HERE TO FILTER EPICS YOU SHOULD USE SIMPLE COTE 'WORD1 WORD2' IF NEEDED", 'is Epic of')

Regards,

Seif, 

Seifallah Bellassoued
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
December 1, 2022

You can use this if you have scriptrunner addon

John K December 1, 2022

Ok, big thank you, let me try this out. :-)

John K December 1, 2022

Ok, and what if you do not have a scriptrunner?

John K December 1, 2022

What would be a potential solution?

John K December 1, 2022

I've also found this blog... but I am not sure how to write the syntax for it....

https://community.atlassian.com/t5/Jira-Software-questions/How-to-filter-by-the-Epic-Link-of-parent/qaq-p/825535

Seifallah Bellassoued
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
December 1, 2022

With native Jira, it is not possible to apply filter on epics. You can only get stories of one epic with this JQL

issue in linkedIssues(EPICKEY-123,"is Epic of")

John K December 1, 2022

correct, I was able to get out put on a single Epic, but if I put a comma and additional epic it will provide output. The limitation is I always need to know the Epic #.

issuetype = Story AND "Epic Link" in (ABC-1234, ABC-1235,etc...)

Suggest an answer

Log in or Sign up to answer