Goal
This section shows the instructions to use JQL function - lookup() to filter projects 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 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 in to 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 lookup JQL function to find all the projects belong to 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
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
|
Supported Fields
IN | NOT IN | = | != | < | > | <= | >= | IS | IS NOT | WAS | WAS IN | WAS NOT | WAS NOT IN | CHANGED |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Other use cases
Save the search as a filter and apply it in dashboard gadget
