Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

JQL Functions

...

Table of Contents
minLevel2

...

Items

Description

datesBeyond

Return all the issues whose time difference between "Date_Field_Name_1" and "Date_Field_Name_2" is greater than or equal to "Time_Frame"

JQL Context

issue in/not in

Time_Frame

Time frame can be w, d, h, m and separated by spaces.

  • w: week

  • d: day

  • h: hour

  • m: minute

Example: "1w 2d 3h 4m"

Date_Field_Name_1&2

Supports

  • "due": issue due date

and any other Date Picker custom fields

JQL Example

issue in dateTimeWithindatesBeyond("3d 8h1w", "createdEstimated Start", "updatedEstimated End")

datesWithin

Code Block
datesWithin("Time_Frame", "Date_Field_Name_1", "Date_Field_Name_2")

...

Items

Description

datesWithin

Return all the issues whose time difference between "Date_Field_Name_1" and "Date_Field_Name_2" is less than or equal to "Time_Frame"

JQL Context

issue in/not in

Time_Frame

Time frame can be w, d, h, m and separated by spaces.

  • w: week

  • d: day

  • h: hour

  • m: minute

Example: "1w 2d 3h 4m"

Date_Field_Name_1&2

Supports

  • "due": issue due date

and any other Date Picker custom fields

JQL Example

issue in dateTimeWithindatesBeyond("3d 8h1d", "createdEstimated Start", "updatedEstimated End")

dateTimeBeyond

Code Block
dateTimeBeyond("Time_Frame", "DateTime_Field_Name_1", "DateTime_Field_Name_2")

...

Items

Description

dateTimeBeyond

Return all the issues whose time difference between "DateTime_Field_Name_1" and "DateTime_Field_Name_2" is greater than or equal to "Time_Frame"

JQL Context

issue in/not in

Time_Frame

Time frame can be w, d, h, m and separated by spaces.

  • w: week

  • d: day

  • h: hour

  • m: minute

Example: "1w 2d 3h 4m"

DateTime_Field_Name_1&2

Supports

  • "created": issue created datetime

  • "updated": issue updated datetime

  • "resolved": issue resolved datetime

and any other DateTime Picker custom fields

JQL Example

issue in dateTimeWithindateTimeBeyond("3d 8h1w", "created", "updated")

dateTimeWithin

Code Block
dateTimeWithin("Time_Frame", "DateTime_Field_Name_1", "DateTime_Field_Name_2")

...