Start Date & End Date

Sorry if this question sounds stupid to you ;-).

I see that Version and Sprint have both a Start Date and an End Date.

I cannot find a way to get these values with a query in a filter (basic or advanced).

And I really would like these to be exported in the Excel that I need to use for reporting and creating a plan in Excel with them.


4 answers

Thank you for the link Daflint but what I am looking for is to be able to extract the start dates and end dates of a Version and a Sprint. They are in the system as we can see them but how to get them? I am not talking about the issues but the parent levels ( version & sprint) . As they are not issues per se, I can' t see the way to get this information. Even structure is only showing issues as I know and not the parent level ( version and sprint). But if I want to export in excel to have a kind of project plan, I need both parents.

If it is the start date and end date of the version which is seen in the classic planning board then this might be helpful for you

Thank you Kannan S, this is indeed what I guess we should be looking for to get these Start/End date for a version and a sprint. I could not find a way to just use the Jira interface and have this extract using a simple filter query nor be able to export data to Excel from these filter. WHile indeed, the information is captured and displayed in some screens in Jira (version) and Agile Board (Sprint), nowehere can then this information be retrieved by a query. In fact, all issues have a Due Date that can be retrieved with a query/filter but Version and Sprint have a start and End date that I cannot retireve, version and sprint being not an issue type . So only access with Api will allow this then... I'll have to ask our developpers if they can manage this...

Can you please elaborate on the start date and end date of the version and sprint that you see. It might be helpful for someone like me to understand where these dates can be seen.

let me know how this is achieved because even i want to do it in a Java jira api way and not using greenhopper service.

Suggest an answer

Log in or Join to answer
Community showcase
Jason Wong
Published yesterday in Agility Beta

Welcome to agility

Every team in the world is unique, and so   Atlassian believes   that each and every team's best way of working  needs to  be molded to their unique circumstances  – ...

381 views 6 16
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot