(Disclaimer: I work on JXL :))
Hope this helps!
Hi @Fabio Paglianti,
here's how it should work:
1.) I create a sheet with a query similar to yours:
2.) I enable the "default hierarchy"; you can see that subtasks are now shown "below" their story/task:
3.) In the "..." menu in the top-right corner of the screen, I chose "Export", and export the sheet:
4.) In the resulting export, subtasks are now grouped below their story/task:
Let me know if this works! If not, I'm happy to jump into a video call and look through it together; just drop us an email at hello at fine dot software.
apologize me - you are right and I am wrong - it works as expected.
My issue is when I try to extract from jira a limited amount of stories, tasks and their subtasks listing in advance the selected epic(s).
It is a jira issue as sub-tasks do not have the epic listed in their attribute
The right query seems to be:
project = DEMOPROJECT AND issuetype in (Story, Task, Sub-task) AND ("Epic Link" in (DEMOPROJECT-546, and so on) OR "Parent Link" in (DEMOPROJECT-609, and so on)) ORDER BY parent ASC, cf ASC, cf DESC, created DESC.
Hello @Prabhu Chilukuri
In order to export the stories and the sub-tasks, it can be done using the JQL.
If you want to group the user stories and sub-tasks as per the user story, that would require an add-on from the Atlassian Marketplace as the 'GROUP BY' functionality is not natively available in Jira.
Please accept the answer of this helps.
Hi everyone! Are you interested in beta testing Atlassian University’s newest (unreleased!) training course? We’re looking for 15-20 volunteers to test our newest training course, Basic reporting...
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