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.

For details please visit https://regexone.com or https://www.regular-expressions.info/java.html

"powerIssue" JQL function

powerIssue([JQL subquery, optional], "field names", "regex expression")

Search by text fields

Case example

Search by user fields

Case example

Search by date fields

To search by date field use pattern "yyyy/MM/dd HH:mm"

Search by fixVersion, affectedVersion fields

Search by sprint

Search by components field

Search by watchers field

Reserved words

As you know, the following English reserved words (also known as 'stop words') are ignored from the search index in Jira and hence, Jira's text search features:

"a", "and", "are", "as", "at", "be", "but", "by", "for", "if", "in", "into", "is", "it", "no", "not", "of", "on", "or", "s", "such", "t", "that", "the", "their", "then", "there", "these", "they", "this", "to", "was", "will", "with"

But not in our app! You can use all or any combinations of this word for text search in "powerIssue" search function. 

"powerComponent" JQL function

powerComponent([JQL subquery, optional], "regex expression") Can be used with 1 or 2 arguments.

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).*")

"powerAttachment" JQL function

powerAttachment([JQL subquery, optional], regex expression)

Case example

issue in powerAttachment(".*(?=android).*(?=pdf).*")

"powerProject" JQL function

powerProject(regex expression)

Case example

project in powerProject(".(Customer).")

"powerWorklog" JQL function

This function allows filtering tickets based on three keywords: comment, total, count. All these keywords filter from worklogs.

Below, there are examples for each one of them.

Search by comment

Examples:

Search by total

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).

It should be noted that one week is 40 hours and one day is 8 hours.

Examples:

Search by count

The keyword "count" allows filtering based on number logged worklog. In order to get result(s), incorporate comparison signs( > , < , != , = ).

Examples:

"powerHistory" JQL function

issue in powerHistory("some JQL", "fieldname", "regex expression")

issue in powerHistory("fieldname", "regex expression")

 Screenshot

Case example:

issue in powerHistory("project = TD", "description", ".*demo space.*")

"powerUser" JQL function

assignee in powerUser("fieldname", "regex expression")

Allowed fields:

• username,
• displayName,
• email,
• preference

Case example:

Find all the tickets where assignee has German location in User Preferences:

assignee in powerUser("preference=jira.user.locale","de.*")

Find all the tickets created by a user which 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):

reporter in powerUser("displayName","(?i).*john.*")

"mentionedWithoutResponse" JQL function

issue in mentionedWithoutResponse("JQL subquery")

issue in mentionedWithoutResponse("JQL subquery", "userName")

Commonly Used Regex

Emails

.*([a-zA-Z0-9._%-]+@[a-zA-Z0-9.-]+\\.[a-zA-Z]{2,6}).*

issue in powerIssue("project is not empty", "comment", ".*([a-zA-Z0-9._%-]+@[a-zA-Z0-9.-]+\\.[a-zA-Z]{2,6}).*")

https links

.*https?:\\/\\/(www\\.)?[-a-zA-Z0-9@:%._\\+~#=]{2,256}\\.[a-z]{2,6}\\b([-a-zA-Z0-9@:%_\\+.~#()?&//=]*).*

issue in powerIssue("project = TEST", "summary", ".*https?:\\/\\/(www\\.)?[-a-zA-Z0-9@:%._\\+~#=]{2,256}\\.[a-z]{2,6}\\b([-a-zA-Z0-9@:%_\\+.~#()?&//=]*).*")

IP v4

.*(([0-9]|[1-9][0-9]|1[0-9]{2}|2[0-4][0-9]|25[0-5])\\.){3}([0-9]|[1-9][0-9]|1[0-9]{2}|2[0-4][0-9]|25[0-5]).*

issue in powerIssue("project = TEST", "summary", ".*(([0-9]|[1-9][0-9]|1[0-9]{2}|2[0-4][0-9]|25[0-5])\\.){3}([0-9]|[1-9][0-9]|1[0-9]{2}|2[0-4][0-9]|25[0-5]).*")

IP v6

.*(([0-9a-fA-F]{1,4}:){7,7}[0-9a-fA-F]{1,4}|([0-9a-fA-F]{1,4}:){1,7}:|([0-9a-fA-F]{1,4}:){1,6}:[0-9a-fA-F]{1,4}|([0-9a-fA-F]{1,4}:){1,5}(:[0-9a-fA-F]{1,4}){1,2}|([0-9a-fA-F]{1,4}:){1,4}(:[0-9a-fA-F]{1,4}){1,3}|([0-9a-fA-F]{1,4}:){1,3}(:[0-9a-fA-F]{1,4}){1,4}|([0-9a-fA-F]{1,4}:){1,2}(:[0-9a-fA-F]{1,4}){1,5}|[0-9a-fA-F]{1,4}:((:[0-9a-fA-F]{1,4}){1,6})|:((:[0-9a-fA-F]{1,4}){1,7}|:)|fe80:(:[0-9a-fA-F]{0,4}){0,4}%[0-9a-zA-Z]{1,}|::(ffff(:0{1,4}){0,1}:){0,1}((25[0-5]|(2[0-4]|1{0,1}[0-9]){0,1}[0-9])\\.){3,3}(25[0-5]|(2[0-4]|1{0,1}[0-9]){0,1}[0-9])|([0-9a-fA-F]{1,4}:){1,4}:((25[0-5]|(2[0-4]|1{0,1}[0-9]){0,1}[0-9])\\.){3,3}(25[0-5]|(2[0-4]|1{0,1}[0-9]){0,1}[0-9])).*

issue in powerIssue("project = TEST", "summary", ".*(([0-9a-fA-F]{1,4}:){7,7}[0-9a-fA-F]{1,4}|([0-9a-fA-F]{1,4}:){1,7}:|([0-9a-fA-F]{1,4}:){1,6}:[0-9a-fA-F]{1,4}|([0-9a-fA-F]{1,4}:){1,5}(:[0-9a-fA-F]{1,4}){1,2}|([0-9a-fA-F]{1,4}:){1,4}(:[0-9a-fA-F]{1,4}){1,3}|([0-9a-fA-F]{1,4}:){1,3}(:[0-9a-fA-F]{1,4}){1,4}|([0-9a-fA-F]{1,4}:){1,2}(:[0-9a-fA-F]{1,4}){1,5}|[0-9a-fA-F]{1,4}:((:[0-9a-fA-F]{1,4}){1,6})|:((:[0-9a-fA-F]{1,4}){1,7}|:)|fe80:(:[0-9a-fA-F]{0,4}){0,4}%[0-9a-zA-Z]{1,}|::(ffff(:0{1,4}){0,1}:){0,1}((25[0-5]|(2[0-4]|1{0,1}[0-9]){0,1}[0-9])\\.){3,3}(25[0-5]|(2[0-4]|1{0,1}[0-9]){0,1}[0-9])|([0-9a-fA-F]{1,4}:){1,4}:((25[0-5]|(2[0-4]|1{0,1}[0-9]){0,1}[0-9])\\.){3,3}(25[0-5]|(2[0-4]|1{0,1}[0-9]){0,1}[0-9])).*")

Date Format YYYY-MM-dd

.*([12]\\d{3}-(0[1-9]|1[0-2])-(0[1-9]|[12]\\d|3[01])).*

issue in powerIssue("project = TEST", "summary", ".*([12]\\d{3}-(0[1-9]|1[0-2])-(0[1-9]|[12]\\d|3[01])).*")

HTML Tags. Elements with Attributes

.*<\\/?[\\w\\s]*>|<.+[\\W]>.*

issue in powerIssue("project = TEST", "description", ".*<\\/?[\\w\\s]*>|<.+[\\W]>.*")