Help with a JQL to obtain the Scheduled Duration and the Actual Start Date of a task

Irvin Mendez

Hi, I need to generate a report with the fields:

• Assignee
• Summary (a specific text)
• Scheduled Duration (Original Stimate in Time i.e. 30m)
• Actual Start Date (wheh the status Change from "To Do" to "In Development")
• Actual Finish Date (wheh the status Change from "In Review" to "Done")
• Actual Duration (Timetracking i.e. 1h)

For this I'm using the plugin Jira Jira Cloud for Excel (official) and My JQL is: 

issuetype = Sub-task AND project = MyProject AND sprint in openSprints() AND reporter in (currentUser()) AND (summary ~ "test1" OR summary ~ "test2" OR summary ~ "test3") 

In the parameters I'm using the following:

• Project
• Reporter
• Issuekey
• Assignee
• Summary
• Resolutiondate
• Timetracking

But I still can't get the information from 

• Scheduled Duration (Original Stimate in Time i.e. 30m)
• Actual Start Date (wheh the status Change from "To Do" to "In Development")

I hope someone can help me.

Thanks,

Zoryana Bohutska _SaaSJet_

Hi @Irvin Mendez 

Also, you can consider add-on Time in Status for Jira Cloud. It lets you monitor time issue spend on each status and total, with all your custom field column. To exclude non-working time, you can set your team schedule at calendars configuration. 

Also, this plugin shows the date and time when each issue entered to each status (report Status Entrance Date)

All data are available as chart and as the gadget for Jira Dashboard.

Hope it helps

Kind Regards