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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Learn More
Use lookup() function to Support multiple categories for Jira Project.