Support mapping between Product Owner and Jira Project

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
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 lookup("Project Table", "Product Owner", "Adam", "Project Key", "all") AND resolution is empty

project in (ACC, ACJ) AND resolution is empty

Lookup Manager project mapping.mp4

Other Tips

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