...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
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
| Expand | ||
|---|---|---|
| ||
project in [DEV, QA, CS] |
...
JQL function - lookup
JQL Syntax
lookup(<Table>, <Lookup Column>, <Lookup Value>, <Mapped Column>, <Mode>)
...
Parameter
...
Description
...
<Table>
...
The lookup table name
...
<Lookup Column>
...
The column name to perform the lookup
...
<Lookup Value>
...
The value used to perform the lookup
...
<Mapped Column>
...
The column name to return if there is any matching row
...
<Mode>
...
The mode for returning values
first will return the first matching value
last will return the last matching value
all will return all the matching value
Supported Fields
...
IN
...
NOT IN
...
=
...
!=
...
<
...
>
...
<=
...
>=
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
IS NOT
...
WAS
...
WAS IN
...
WAS NOT
...
WAS NOT IN
...
CHANGED
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