/
Support multiple categories for Jira Project

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

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 [DEV, QA, CS]

Other Tips

  1. Save the search as a filter and apply it in dashboard gadget

     

Learn More

Related content

Support mapping between Product Owner and Jira Project
Support mapping between Product Owner and Jira Project
More like this
JQL function - lookup
JQL function - lookup
More like this
Mapping a Cascading Select List Option to Your Lookup Table
Mapping a Cascading Select List Option to Your Lookup Table
Read with this
How to allow users to search 1 single field from a dropdown list or a text box
How to allow users to search 1 single field from a dropdown list or a text box
More like this
I can't see all projects I'm involved with in the project dropdown
I can't see all projects I'm involved with in the project dropdown
More like this
Associate Dashboard to Project (Project Dashboard)
Associate Dashboard to Project (Project Dashboard)
More like this