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,

[Bloompeak Support]

Hi @Irvin Mendez ,

You can use Status Time add-on. It generates time spent on each status based on a calendar(7/24 or working hours) as well as status entrance dates.

If you are looking for a free solution, you can try Status Time Free. 

[Irvin Mendez]

It looks great, I'll take a look. 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

[Irvin Mendez]

Sounds good, I will try. Thanks.