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

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.

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...

Unfortunately I can't run Greenhopper in my system. 

I do not understand why a simple query I am trying to create is appearing so complex to achieve....

I need a list of issues COMPLETED in the previous sprint using JQL and without naming the specific sprint each time. 

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.

Suggest an answer

Log in or Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published Apr 22, 2018 in Jira Software

How-to setup a secured Jira Software 7.9.0 on Ubuntu 16.04.4 in less than 30 minutes

...PermissionsStartOnly=true User=www-data Group=www-data ExecStart=/opt/jira/bin/ ExecStop=/opt/jira/bin/ TimeoutStartSec=120 TimeoutStopSec=600 PrivateTmp=true [Install] WantedBy...

447 views 5 6
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