Field Comprassion

• Field Comparisons JQL Functions

  • DateCompare()

  • DateCompareIgnoreTime()

• Field Comparisons JQL Keywords

  • HasSameUpdatedAndCreatedDate

  • HasSameAssigneeAndReporter

  • HasSameVersions

Field Comparisons JQL Functions

DateCompare()

Finds issues where date fields satisfy a specified comparison expression.

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

Examples:

• issue in dateCompare("created >= duedate") finds issues where the creation date is on or after the due date.

• issue in dateCompare("'Start Date' < 'End Date'") retrieves issues where the custom field Start Date is before End Date.

DateCompareIgnoreTime()

Similar to dateCompare(), but compares only the date parts of the timestamps, ignoring the time.

Examples:

• issue in dateCompareIgnoreTime("updated = resolved") finds issues where the date of last update and the resolution date are the same, ignoring the time of day.

• issue in dateCompareIgnoreTime("'Planned Release Date' <= 'Actual Release Date'") retrieves issues where the planned release date is on or before the actual release date, comparing only the dates.

Field Comparisons JQL Keywords

HasSameUpdatedAndCreatedDate

Searches for issues that have not been updated since they were created.

SUPPORTED OPERATORS 

Example:

• hasSameUpdatedAndCreatedDate = true finds issues where the updated date is the same as the created date. 

HasSameAssigneeAndReporter

Searches for issues where the assignee and reporter are the same user.

SUPPORTED OPERATORS 

Example:

• hasSameAssigneeAndReporter = true retrieves issues assigned to the person who reported them. 

HasSameVersions

Searches for issues where the fix versions and affected versions are identical.

SUPPORTED OPERATORS 

Example:

• hasSameVersions = true finds issues where the same version is listed in both the fix versions and affected versions fields.