Find board url given sprintID but no rapidViewID?

Question

I have the sprintID from hovering over the board on the Jira and picking out the GHGoToBoard.jspa?sprintId=7530. I never find the View on Board option useful as it produces a big list always. This sprint is a few years old and I don't know the board that was used.

Given only the project and the sprintId is there any way to find a url for the board?

Andy Heinzer · Answer

Sorry, I should have clarified.  Yes, the method I suggested above would require you to have access to the database that Jira is using.  Typically I would not expect you to have this information unless you are an administrator of Jira or a SQL admin.   If you were an admin to Jira, then you could probably navigate to the filesystem that Jira is on, and go into the $JIRAHOME/dbconfig.xml   this file contains the connection string Jira is using to connect to that SQL database as well as the username and password.

If this is not something you have access to, then you might just want to forward that SQL query on to your database administrator and have them return the results to you.

boardtc · Answer

Yes, the rapidView number is what's sought!

Are you talking about installing mysqladmin or something to be able to run sql? I don't have admin access. I'm unsure of the jdbc connection string & port to use if I did that.

Andy Heinzer · Answer

You could use a SQL query like this one to find all the sprints, and in turn all the Boards where these sprints were created.

Select "AO_60DB71_SPRINT"."ID" as sprint_ID, "AO_60DB71_SPRINT"."NAME" as sprint_name, "AO_60DB71_RAPIDVIEW"."NAME" as board_name, "AO_60DB71_SPRINT"."RAPID_VIEW_ID" as board_id 
from "AO_60DB71_SPRINT"
join "AO_60DB71_RAPIDVIEW" on "AO_60DB71_SPRINT"."RAPID_VIEW_ID"="AO_60DB71_RAPIDVIEW"."ID";

Granted sprints can exist on multiple boards simultaneously.  However when a sprint is first created, it has an 'origin board' value of sorts that is defined.  By looking between these two AO tables in the jira database you can figure out which board created that sprint, and in turn you can find the rapid_view_id value.  That value could be used to reach the board directly, if you have access to view it.   The URL would look something like this:

/secure/RapidBoard.jspa?projectKey=SCRUM&rapidView=6

where the rapidView value corresponds to the "AO_60DB71_SPRINT"."RAPID_VIEW_ID" value.