I want to be able to query for open Stories and Tasks within open Epics. What JQL can I use for this query? When I pull in "Status", it seems to be the status of the Story or Task, not not for the Epic. I need to be able to distinguish between the two status'.
Hi @bangaru ganesh -- Welcome to the Atlassian Community!
I do not believe you can do that with out of the box Jira, as JQL is not a full SQL language. You would need a scripting add-on from the marketplace.
As a work-around, you could export the project issues to a spreadsheet, or use the Excel or Google Sheets addons for Jira, and perform the join manually between the open issues and their open epics.
As an alternative you may want to try out our add-on to manage multiple Epics and their hierarchy on a single page.
Manage and visualize your Epics with rolled up estimate progress reports.
Catch up with Atlassian Product Managers in our 2020 Demo Den round-up! From Advanced Roadmaps to Code in Jira to Next-Gen Workflows, check out the videos below to help up-level your work in the new ...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events