Jira: URL for report view of the active sprint?

[Ken Basye]

Hi,

With a URL like

foo.com/RapidBoard.jspa?rapidView=2803&view=reporting&chart=sprintRetrospective&sprint=4871

I can get the reporting view for a particular sprint.

With a URL like foo.com/RapidBoard.jspa?rapidView=2803

I get the work view for the currently active sprint. But with

foo.com/RapidBoard.jspa?rapidView=2803&view=reporting&chart=sprintRetrospective

It seems like I get the reporting view for the most recently *completed* sprint.

My question is this: is there a way to get the reporting view for the currently active sprint without having the sprintID? I'd like to put a URL in a separate Confluence page that always points to that view for the current sprint without having to update the sprintID whenever a new sprint is started.

Thanks!

[Diego Zarpelon]

Hey Ken.

I don't think that this can be done. But sprint ids are auto incremented. so if you know the sprint velocity ( at least when one starts and the other finishes you can easily create a script that test that for you.

If you want to know if a sprint is active you can look at your db with the following query

select * from AO_60DB71_SPRINT

If you are using a script you can run this sql query:

select id from AO_60DB71_SPRINT where started=1 and complete_date is NULL

The above query will give you all active sprints.

Please remember tha this is a MySQL query. So you should adjust it to your specific db syntax.

Hope this helps!