Support mapping between Product Owner and Jira Project
- Cao Liang
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
Other Tips
Save the search as a filter and apply it in Multiple Filters Chart Gadget
Learn More
Use lookup() function to Support multiple categories for Jira Project