Below query can be used for finding the details of Closed date in Human readable format in MySql database
select ID,Name, FROM_UNIXTIME(Start_DATE/1000),FROM_UNIXTIME(COMPLETE_DATE/1000) as completed_dates from AO_60DB71_SPRINT where FROM_UNIXTIME(COMPLETE_DATE/1000) >= '2015-06-01' and closed = 1;
Actually in Sprint table date's are stored in Big Int format(20 digits may be) so need to change it using FROM_UNIXTIME
I've seen the dropdown list on a Rapidboard that shows past (closed) sprints, but cannot figure out how it got there. The user was able to use the dropdown and see a list of closed sprints she could view without using the reports.
The only thing we can see on past sprints in the Reports view is the data from the reports, not a Rapidboard.
Is there a way to show the dropdown on the Rapidboard in the location noted in the attached image?
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!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
We're bringing product updates and pro tips on teamwork to ten cities around the world.Save your spot