Try it free: ☁Cloud 🖥Data Center
| Info |
|---|
The instructions on this page describe how to execute a JQL search using JQL Search Extensions. |
| Table of Contents | ||||||
|---|---|---|---|---|---|---|
|
Field Comparisons JQL functions
| Info |
|---|
JQL functions are accessible from Extended Search screen or via Extended Search filters in Jira advanced search. |
DateCompare()
Find issues with dates matching an expression.
Expression consists of 2 date fields connected with a comparision operator: <, <=, >, >=, =
issue in dateCompare("duedate < resolved")
issue in dateCompare("'Target date' >= 'Start date'")
DateCompareIgnoreTime()
Find issues with dates matching an expression. This function takes into account only the date part of the timestamps.
Expression consists of 2 date fields connected with a comparision operator: <, <=, >, >=, =
issue in dateCompareIgnoreTime("duedate < resolved")
issue in dateCompareIgnoreTime("'Target date' >= 'Start date'")
Field Comparisons JQL Aliases
HasSameUpdatedAndCreatedDate
Search for issues which were not updated since creation
SUPPORTED OPERATORS
= | != | ~ | !~ | > | >= | < | <= | IS | IS NOT | IN | NOT IN | WAS | WAS IN | WAS NOT | WAS NOT IN | CHANGED |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
EXAMPLES
| Code Block |
|---|
hasSameUpdatedAndCreatedDate = "true" |
HasSameAssigneeAndReporter
Search for issues with the same assignee and reporter
SUPPORTED OPERATORS
= | != | ~ | !~ | > | >= | < | <= | IS | IS NOT | IN | NOT IN | WAS | WAS IN | WAS NOT | WAS NOT IN | CHANGED |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
EXAMPLES
| Code Block |
|---|
hasSameAssigneeAndReporter = "true" |
HasSameVersions
Search for issues with the same fix and affected versions.
SUPPORTED OPERATORS
= | != | ~ | !~ | > | >= | < | <= | IS | IS NOT | IN | NOT IN | WAS | WAS IN | WAS NOT | WAS NOT IN | CHANGED |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
EXAMPLES
| Code Block |
|---|
hasSameVersions = "true" |