"." (dot) is another example of a regular expression. A dot matches with any single character; it matches, for example , with "a" or "1". The following table lists contains several regular expressions and describes with which search query pattern they would match.
|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".|
^ 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".
|Any issue where sprint name contains "sample" (case-insensitive)||issue in powerIssue("sprint", "(?i).*(sample).*")|
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).*")
"powerWorklog" JQL function
This function allows to filter filtering tickets based on three keywords: comment, total, count. All these keywords filter from worklogs.
Search by total
This keyword, The keyword "total" , allows filtering based on worked time. In order to get result(s), incorporate comparison signs( > , < , != , = ) and letters ( w=week , d=day , h=hour , m=minute).
Search by count
This The keyword , "count" , allows filtering based on number logged worklog. In order to get result(s), incorporate comparison signs( > , < , != , = ).
Find all the tickets where assignee has German locale location in User Preferences:
assignee in powerUser("preference=jira.user.locale","de.*")
Find all the tickets created by a users user which user names username starts with "andr":
creator in powerUser("username","andr.*")
Find all the tickets where Reporter's display name contains "john" case-insensitive ("(?i)" search modifier):