Defining Lookup Queries for Jira Servers

When using a lookup query to retrieve data from a target server of type Jira cloud, the following rules apply:

Form	Query
Group	You can only query using the name field, for example: [name] = 'Human Resources' Use this lookup to retrieve the Group Id for a named group.
Issue	This lookup supports a subset of JQL (Jira Query Language). The following operators are supported: = != > < >= <= CONTAINS (set to jql equivalent '~' when the query is sent to Jira). The following operators are not supported: IN, NOT IN, !~ (DOES NOT CONTAIN), IS, IS NOT, WAS, WAS IN, WAS NOT IN, WAS NOT, CHANGED. The following keywords are supported: AND OR NOT NULL The following keywords are not supported: EMPTY ORDER BY JQL functions are also not supported. Example: [summary] CONTAINS '#!Incident Number!#' Useful to retrieve the Issue Id for an incident which is then used to create the related Comment or Work Log.  If you do need to use the full functionality of JQL, you can make use of the Server Query as described here although temporary variables cannot be embedded in the query.
Organization	You can only query using the name field, for example: [name] = 'Service Management Integrations' Use this lookup to retrieve the Organization Id for a named organization.
Confluence Page	This lookup supports a subset of CQL (Confluence Query Language). The following operators are supported: = != > < >= <= CONTAINS (set to cql equivalent '~' when the query is sent to Jira). The following operators are not supported: IN, NOT IN, !~ (DOES NOT CONTAIN). The following keywords are supported: AND OR NOT NULL The ORDER BY keyword is not supported Example: [title] CONTAINS '#!Article Title!#' Useful to retrieve the Page Id for a page which is then used to create the related Comment.  If you do need to use the full functionality of CQL, you can make use of the Server Query as described here although temporary variables cannot be embedded in the query.
Request Type	You can only query using the name field, for example: [name] = 'Request new hardware' Use this lookup to retrieve the Request Type Id for a named request type.
User	You can query using the Email Address or Display Name, for example: [emailAddress] = #SRC.email# Note that Jira will still search both the Email Address and Display Name fields for the value provided on the right-hand side of the query. Use this lookup to retrieve the Account Id for the named user.
Confluence Space	You can query using the name or Key field, for example: [name] = #!KB!# Use this lookup to retrieve the Space Id for a named Confluence Space.
Object Icon	You can only query using the name field, for example: [name] = 'Printer' Use this lookup to retrieve the Icon Id for a named icon.
Object Type	Logical operators are not supported, you should use a query in the format: [name] = '<value>' For example, [name] = #SRC.name# Use this to obtain the objectTypeId for a named object type.
Object Type Attribute	Logical operators are not supported, you should use a query in the format: [name] = '<value>' For example, [name] = #SRC.name# Use this to obtain the attribute id for a named object type attribute.