I am trying to find the JQL to fetch issues and related subtasks in a particular sprint in JIRA

[syamasundararao ratti]

I am trying to find the JQL to fetch issues and related subtasks in a particular sprint in JIRA but I could not able to find any JQL. Could anyone please help me on this.

with this JQL I am looking for tasks-->subtasks-->who worked on which task and how much time they logged work. For this first we need a JQL filter to get details. So that I can make a tempo time report out of it.

Thank you.

[Ollie Guan]

Hi  @syamasundararao ratti,

You can implement the query in the following two steps:
1. Query all the issues in the sprint, like Sprint = "sprint name"
2. Configure Columns and select the fields that need to be displayed, such as Assignee, Time spent, etc.

[syamasundararao ratti]

Hi, 

Thanks for your reply. Whether it will show all the subtasks under a task. I have doubt on this.

[Ollie Guan]

Yes, I think the query results should include the issue and subtasks in the sprint.

[syamasundararao ratti]

Thank you.Yes I selected subtasks from column and now I can see subtasks w.r.to main task. 

But I want to make a report from tasks and subtasks who logged how much time on each task and subtask using tempo reports.

[Susanne Götz _Tempo_]

Hi,

to view this filter in Tempo Reports, you can either select Tempo, Reports, JIRA filter Report or the Custom report and filter by this filter.

To view the worklogs of other users on Issues within this filter, you need to have the "View all worklogs" permission for all Projects that are included in this filter. Please note that only issues that work has been logged on in the selected time period will be displayed.

Regards,
Susanne Götz
Tempo team