Creating Dynamic Links to Jira Align Work Items for Custom Jira Align Enterprise Insights Reports

[#1]

Jira Align Enterprise Insights enables you to create custom reports and dashboards with your existing data visualization platform (ex. Power BI, Tableau, etc.). While viewing a custom report or dashboard, your users may want to view the related work item data in Jira Align. This requires users to manually search for a work items in using the work item search in the Jira Align UI.

Wouldn't it be great if you could have hyperlinks in your custom reports that your users can click on that directly open work items in Jira Align? 

It's possible to dynamically create links in your customer reports and dashboards that directly link to a Jira Align work item. So when a user clicks on a link in the report it will open the detail panel slide out for the work item in Jira Align. This article provides an overview on how to construct dynamic URLs to link directly to Jira Align work items which can be embedded in a custom report. 

Before starting, you must know how to create hyperlinks using an expression or formula to dynamically construct a URL link by concatenating values in your own data visualization tool (ex. Power BI Desktop, Tableau Desktop, etc.) which is not covered in this article.

Steps for Constructing a Dynamic Link

Base URL Direct Link Structure

[current_dw].[Site Metadata].[Server]/[Grid Name]Grid?FirstTime=True&[Object Type]ID=[Jira Align ID#]

The following steps provide instructions to replace the elements in bold in the above base URL direct link structure.

1. Jira Align site URL is available in the Server column of the Site Metadata table ( [current_dw].[Site Metadata].[Server] ) Ex. https://atlassian.jiraalign.com

2. Replace [Grid Name] and [Object Type] with values in the corresponding columns in the table below for the Jira Align object you want to construct a direct link for.

Note: For Objectives, replace both [Grid Name]Grid in the Base URL direct link structure with value in the Grid Name column for Objective.

 /AddMilestone?FirstTime=True&MilestoneID=

Jira Align Object	Grid Name	Object Type
Theme	Theme	Theme
Epic	Epic	Epic
Capability	Capabilities	Capability
Feature	Request	Feature
Story	Story	Story
Defect	Defects	Bug
Task	Task	Task
Objective	AddMilestone	Milestone
Risk	Risk	Risk
Dependency	Dependent	Dependency
Impediments	Blocker	Blocker
Team	Team	Team
Release (a.k.a. Program Increment, Quarter, etc.)	Project	Release
Release Vehicle	ReleaseVehicle	Vehicle

3. Replace [Jira Align ID#] with the value of the column in Enterprise Insights table that contains the Jira Align ID of the object (ex. Feature ID)

Below is an example of a URL that links to directly to feature. The parts of the URL in bold are values that have been replaced in the base URL direct link structure.

https://atlassian.jiraalign.com/RequestGrid?FirstTime=True&FeatureID=1

This is one more tool that you can add to your tool chest that will enable you to extend the experience of your Enterprise Insights custom reports and dashboards for your users.