Support multiple categories for Jira Project

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

project in lookup("Project Category Table", "Category", "BUSINESS", "Project Key", "all")

project in [DEV, QA, CS]

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