Epic link query

Question

I have 20 epics that my team is working on. The projects are different. I want to create a quick filter to see stories by an epic (not hardcode epic numbers)

example - if i have 5 stories in a sprint tagged to Epic A, 3 to Epic B , 2 to Epic C And so on.. how to view them based on the epic A, B C

none of the queries seem to be working apart from hard coding.

Piyush Annadate _ACE Pune_ · Answer

Thanks for Confirmation. With said, native JQL may not provide you such details, you may write a small script  (locally using Python/etc) to fetch the EPIC, check their Sprint and required data and export into CSV or something.

Few ideas:

Create a Board/Plan/Roadmap having filter for project and active Sprint

project=XYZ and Sprint in openSprints() <and other conditions>

Visit Board -> Kanban Board -> Group by Epic -> And you will have the required the Story/Child issues group by Epic

Srk K · Answer

Thank you Piyush.
No, we dont have them enabled.

Piyush Annadate _ACE Pune_ · Answer

Hello @Srk K ,
Welcome to the community. 
Dynamic filter for the EPIC based or parent based is an challenge with the direct JQL. Do you have additional plugins such as ScriptRunner, JXL, etc?