How to find Jira Data Center Advanced Roadmaps share link IDs in the database?
Platform Notice: Data Center - This article applies to Atlassian products on the Data Center platform.
Note that this knowledge base article was created for the Data Center version of the product. Data Center knowledge base articles for non-Data Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Summary
In order to identify the data related to a plan shared outside of Advanced Roadmaps (in Confluence for example) , it's possible to see the relative data in Jira's database by tracing back the id in the shared URL
Diagnosis
- Bellow are examples of possible shared links from a plan
- ../secure/PortfolioEmbeddedReportView.jspa?r=snR7L
- ../secure/PortfolioRoadmapConfluence.jspa?r=snR7L
Solution
To identify where the data on the link is coming from we can use the ID in the request parameter(in the previous example it's 'snR7L') which is a random alphanumeric string of a length of 5 characters , Advanced Roadmaps stores an entry on the table AO_D9132D_GENERICREPORT with that hash the first time you click on the share button. So basically you can see the type (Plan for example ) and it's ID in type_id column. The PARAMS column contains other important information such as the scenario ID/team/project etc .