Field values

The examples on this page describe how to build 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. When using functions, the issues returned are based on the subquery defined in parentheses.

dateCompare()

Find issues with dates matching an expression.

The expression consists of 2 date fields connected with a comparison operator: <, <=, >, >=, =.

Examples

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: <, <=, >, >=, =.

Examples

issue in dateCompareIgnoreTime("duedate < resolved")

issue in dateCompareIgnoreTime("'Target date' >= 'Start date'")

Field value comparisons 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

=

!=

~

!~

>

>=

<

<=

IS

IS NOT

IN

NOT IN

WAS

WAS IN

WAS NOT

WAS NOT IN

CHANGED

Example

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

=

!=

~

!~

>

>=

<

<=

IS

IS NOT

IN

NOT IN

WAS

WAS IN

WAS NOT

WAS NOT IN

CHANGED

Example

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

=

!=

~

!~

>

>=

<

<=

IS

IS NOT

IN

NOT IN

WAS

WAS IN

WAS NOT

WAS NOT IN

CHANGED

Example