Skip to main content
Skip table of contents

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

Other Tips

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

Learn More

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.