Support multiple categories for Jira Project
- Cao Liang
Goal
This section shows the instructions to use the JQL function - lookup() to filter projects that belong to the same category.
Pre-requisites
✔️ Create a lookup table
✔️ Lookup Table Edit permission
Demonstration
Jira only allows a project to be in one category. It is not possible for the user to assign multiple categories to a project in JIRA. Lookup Manager gives the user the power to group projects into different categories so the user can quickly filter projects and find what they are looking for.
Step 1: Create a Lookup Table to group projects into different category
Project Key | Project Name | Category |
|---|---|---|
DEV | Development project | BUSINESS |
QA | QA project | BUSINESS |
QA | QA project | INTERNAL |
CS | Customer Service project | BUSINESS |
CS | Customer Service project | CUSTOMER |
FRAM | Framework Development project | CUSTOMER |
FRAM | Framework Development project | INTERNAL |
Step 2: Use the lookup JQL function to find all the projects that belong to the BUSINESS category
Look up the Project Category Table and search the column Category which matches BUSINESS. 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 dashboard gadget
Learn More
Use lookup() function to Support mapping between Product Owner and Jira Project