Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root


1 badge earned


Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!


Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.


Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!


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

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.

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.




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.

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.



Log in or Sign up to comment
AUG Leaders

Atlassian Community Events