Goal
This section shows the instructions to use lookup JQL function 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.
...
| Expand | ||
|---|---|---|
| ||
project in [DEV, QA, CS] |
...
JQL function - lookup
JQL Syntax
lookup(<Table>, <Lookup Column>, <Lookup Value>, <Mapped Column>, <Mode>)
...
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
