/
Support mapping between Product Owner and Jira Project

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

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

 

 

Related content

JQL function - lookup
JQL function - lookup
More like this
How to append values to multi-select fields
How to append values to multi-select fields
More like this
Config Rule in Automation for Jira (New)
Config Rule in Automation for Jira (New)
Read with this
Support multiple categories for Jira Project
Support multiple categories for Jira Project
More like this
User Guide
User Guide
Read with this
Tutorial - Lookup the stakeholders based on the application
Tutorial - Lookup the stakeholders based on the application
More like this