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'.
Hello,
You can try the following JQL :
issuetype IN (Story, Task) AND "Epic Status" != Done
Let me know if it helped,
Guilhem
As an alternative you may want to try out our add-on to manage multiple Epics and their hierarchy on a single page.
Agile Tools - Epic Tree and Time in Status
Manage and visualize your Epics with rolled up estimate progress reports.
Key features:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
Best regards,
Bill
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.