Support mapping between Product Owner and Jira Project

Owned by Cao Liang
Last updated: Mar 30, 2021
1 min read

Goal

This section shows the instructions to use the JQL function - lookup() to find outstanding request belonging to a product owner.

Pre-requisites

✔️ Create a lookup table
✔️ Lookup Table Edit permission

Demonstration

As a program manager, I might want to see the outstanding requests belonging to the Product Owner. However, the relationship between the Product Owner and Jira Project is not defined in the issue.

Step 1: Create a Lookup Table to define the relationship between the Product Owner and the Project

Project Key

Product

Product Owner

Scrum Master

QA Manager

Tech Lead

Project Key

Product

Product Owner

Scrum Master

QA Manager

Tech Lead

ACC

Attachment Checker for Confluence

Adam

Charle

Feya

Nile

MCHART

Multiple Filters Chart Gadgets

Bob

Charle

Denton

Nile

ACJ

Attachment Checker for Jira

Adam

Charle

Rob

Nile

Step 2: Use the lookup JQL function to find all the outstanding requests belonging to Adam.

Look up the Project Table and search the column Product Owner which matches Adam. For those matching rows, it will collate All the corresponding values in the Project Key column 

 

project in (ACC, ACJ) AND resolution is empty

 

Other Tips

  1. Save the search as a filter and apply it in Multiple Filters Chart Gadget

     

Learn More