Can anyone help me with extracting a report with all the sub-tasks under a project, along with their corresponding Tasks numbers and group them by Task numbers? I'm okay with JQL as well.
Hi Santhosh,
To find sub-tasks in a project along with their parent issue from Atlassian Analytics, you can query the Jira "Issue field" table in the Atlassian Data Lake to filter on Name=Parent and then join it with data from the Jira "Issue" table. This article walks through the steps in detail: https://confluence.atlassian.com/analyticskb/query-parent-and-child-issues-from-jira-1206787653.html
Please let me know if you have any questions on this.
Tracy
Hi @SanthoshMR
This might be a start but we need more info.
Project = PROJECT_KEY AND issuetype = "Sub-task" ORDER BY parent ASC
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks for this, Frederik. I however not able to see the parent ticket numbers in my result. The "Type" is Sub-task and Task for child and parent tickets. I'd like to to list all the Sub-tasks along with their Task numbers.
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.