This very powerful JQL function combines the power of classic JQL and JWT, by letting you refine your JQL subquery using a JWT logical expression.
The function works in the following way:
-
The JQL subquery will be evaluated first and return a number of issues
-
These issues will then be run against a logical expression
-
Issues where the expression returns TRUE will be returned by the overall JQL query
Example
issue in issueSelection('project = DESK', '%{issue.subtasks.count} >= 1')
-
The JQL subquery will return all issues from the DESK project
-
The logical expression will check whether these issues have at least one sub-task.
-
The JQL function will only return the issues with sub-tasks.
Syntax
issueSelection(subquery, logicalExpression) #Output: Issue list
Examples
|
Parser expression |
Description |
|---|---|
|
Bash
|
This example returns all issues within the QA project where the reporter is also the current assignee. |
|
Bash
|
This examples returns all stories that have at least one sub-task. |
|
Bash
|
This example returns all issues within the CRM project with more than 10 comments. To achieve this, the following functions are used: |
|
Bash
|
This example returns all issues from projects within the Support category with unresolved sub-tasks. To achieve this, the following functions are used: |
|
Bash
|
This example returns all tasks that have been created by cloning an issue. To achieve this, the following functions are used: |
|
Bash
|
This example returns all issues within the KANBAN project that are assigned to users in the Developers role. To achieve this, the following functions are used: |
|
Bash
|
This example returns all Incidents with a change of priority within the last 60 minutes. To achieve this, the following functions are used: |
|
Bash
|
This example returns all unresolved Bugs with a 'EAP'-labelled version. |
|
Bash
|
This example returns all issues within the HR project that are assigned to inactive users. |
|
Bash
|
This example returns all issues within the JWT project that have at least one PDF file attached. |
Additional information
Parameters used in this function
|
Parameter |
Input (data type) |
Description |
|---|---|---|
|
|
text |
A JQL query to select the issues that should be further filtered by the logical expression. ⚠️ The subquery must not be empty to avoid negative performance impacts. Always try to keep the number issues returned by the subquery as minimal as possible. |
|
|
text |
A logical expression that returns a boolean value. See additional examples and learn how to build logical expressions here. |
Output
This function returns an issue list
The result is not what you expected? The number of returned issues feels too low?
By default, the maximum number of issues that will be returned by the JQL subquery, and thus can be processed by the logical expression is 1000.
To ensure the performance of your entire Jira instance, we limit the execution of the JQL function in terms of issue count and execution time. Please refer to your admin if you need to change the Performance settings .