It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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.

Pierre

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

https://answers.atlassian.com/questions/105507/greenhopper-rapidboard-rest-api-calls-to-retrieve-startdate-enddate

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
Community showcase
Published in Jira Software

Early Access: If you use Jenkins and Jira Software Cloud, you need to read this!

The Jira Software Cloud Team has been busy working on a simple, secure, and reliable way to integrate your build and deployment information from Jenkins with Jira Software Cloud. This means you don’t...

2,064 views 2 18
Read article

Community Events

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

Find an event

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

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you