Info |
---|
The development of Power JQL put on hold. Please subscribe to updates on the marketplace and stay tuned. |
Additional and useful JQL functions to search issues using the power of regex expressions. |
...
Table of Contents |
---|
Regex expressions
A simple example of a regular expression is a (literal) string. For example, the "Hello World" regex matches the "Hello World" string.
"." (dot) is another example of a regular expression. A dot matches with any single character, for example "a" or "1". The following table contains several regular expressions and describes with which search query pattern they would match.
Regex | Matches |
---|---|
this is text | Matches exactly "this is text" |
this\s+is\s+text | Matches the word "this" followed by one or more whitespace characters followed by the word "is" followed by one or more whitespace characters followed by the word "text". |
^\d+(.\d+)? | ^ defines that the pattern of the search query must start with the beginning of a new line. \d+ matches one or several digits. The ? makes the statement in brackets optional. . matches ".", brackets are used for grouping. Matches for example with "5", "1.5" and "2.21". |
For details please visit https://regexone.com or https://www.regular-expressions.info/java.html
...
Search by text fields
Field | JQL |
---|---|
summary | issue in powerIssue("summary", ".*") |
description | issue in powerIssue("description", ".*") |
Case example
Task | JQL |
---|---|
Simple usage - find any issue with the word "amber" in the beginning of the Summary field | issue in powerIssue("summary", "(amber).*") |
Any issue from POWERJQL project, where summary or description contains "text1" or "text2" (case-insensitive) | issue in powerIssue("project=POWERJQL", "summary, description", "(?i).*(text1 | text2).*") |
Search by user fields
Field | JQL |
---|---|
assignee | issue in powerIssue("assignee", "Jackson") |
reporter | issue in powerIssue("reporter", "Lucas") |
creator | issue in powerIssue("creator", "Liam") |
Case example
Task | JQL |
---|---|
Any issue where assignee name contains "Michael" (case insensitive) | issue in powerIssue("assignee", "(?i).*(Michael).*") |
Search by date fields
To search by date field use pattern "yyyy/MM/dd HH:mm"
Field | JQL |
---|---|
created | issue in powerIssue("created", "2017.*") |
updated | issue in powerIssue("updated", "2017/08/26.*") |
due, duedate | issue in powerIssue("due", "2017/08/26.*") |
resolutiondate | issue in powerIssue("resolutiondate", "2017/08.*") |
Search by fixVersion, affectedVersion fields
Field | JQL | Notes |
---|---|---|
fixVersion | issue in powerIssue("fixVersion", ".(8\.5.).") | to find all tickets with fix versions like 8.5.1, 8.5.2, 8.5.1.1 etc. |
affectedVersion | issue in powerIssue("affectedVersion", ".(1\.0.).") | to find all tickets with affected versions like 1.0.1, 1.0.2, 1.0.1.1 etc. |
Search by sprint
Sprint | JQL |
---|---|
Any issue where sprint name contains "sample" (case-insensitive) | issue in powerIssue("sprint", "(?i).*(sample).*") |
Search by components field
...
Expand | ||
---|---|---|
| ||
Case example
Any not resolved issues where any component contains words "mobile" or "dev" in any part of component name (case-sensitive):
component in powerComponent("resolution=EMPTY", ".*(mobile | dev).*")
...
"powerHistory" JQL function
issue in powerHistory("some JQL", "fieldname", "regex expression")issue in powerHistory("fieldname", "regex expression")
Expand | ||
---|---|---|
| ||
Case example:
...
"powerUser" JQL function
assignee in powerUser("fieldname", "regex expression")
Allowed fields:
- username,
- displayName,
- email,
- preference
...
Case | JQL | Notes |
---|---|---|
1 | issue in mentionedWithoutResponse("JQL subquery") | to get all tickets where the current user has been mentioned but without response |
2 | issue in mentionedWithoutResponse("JQL subquery", "userName") | to get all tickets where "userName" has been mentioned but without response: |
3 | issue in mentionedWithoutResponse("JQL subquery", "currentUser()") | to get all tickets where current logged in user has been mentioned without response |
...