Field values
The instructions on this page describe how to execute a JQL search using JQL Search Extensions.
Field value comparisons JQL functions
JQL functions are accessible from the Extended Search page or Extended Search filters in Jira advanced search.
DateCompare()
Find issues with dates matching an expression.
The expression consists of 2 date fields connected with a comparison 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.
The expression consists of 2 date fields connected with a comparison operator: <, <=, >, >=, =
issue in dateCompareIgnoreTime("duedate < resolved")
issue in dateCompareIgnoreTime("'Target date' >= 'Start date'")
Field value omparisons JQL keywords
HasSameUpdatedAndCreatedDate
Search for issues that have not been updated since the creation date.
SUPPORTED OPERATORS
= | != | ~ | !~ | > | >= | < | <= | IS | IS NOT | IN | NOT IN | WAS | WAS IN | WAS NOT | WAS NOT IN | CHANGED |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
EXAMPLES
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
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
hasSameVersions = "true"