Versions Compared

Old Version 3

changes.mady.by.user Morgan Folsom (Deactivated)

Saved on

compared with

New Version Current

changes.mady.by.user Morgan Folsom (Deactivated)

Saved on

Key

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

JQL Functions

...

Table of Contents

...

minLevel2

...

datesBeyond

Code Block

...

datesBeyond("

...

Time_

...

Frame", "

...

Items

Explanation

JQL: FieldValueMatches

Return all the issues whose specific field value matches the "Regex_Pattern"

JQL Context

issue in, issue not in

Field_Name

Support any text-based fields. i.e. "Summary", "Description", ' text field (single line)', etc.

Regex_Pattern

Support any regular expression patterns

JQL Example

issue in FieldValueMatches("summary", "[hm]at") will return all the issues whose summary contains hat or mat

Previous Status* REVIEW jql example. are quotes needed around spaced status names?

Code Block
preStatusWas("status_A")
preStatusContainsAll("status_A, status_B, status_C,..., status_X")
preStatusContainsEither("status_A, status_B, status_C,..., status_X")

...

Items

...

Explanation

...

preStatusWas

...

Return all the issues whose most recently previous status is status_A

...

preStatusContainsAll

...

Return all the issues whose historical statuses (excluding current status) include status_A and status_B and status_C and ... and status_X

...

preStatusContainsEither

...

Date_Field_Name_1", "Date_Field_Name_2")

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

statusTime_X

Support all Jira workflow statuses

JQL Example

Four example issues with their workflow transition history:

  1. TK-1: Open

  2. TK-2: Open → In Progress

  3. TK-3: Open → In Progress → Under Review

  4. TK-4: Open → In Progress → Under Review → Rejected → In Progress

'issue in preStatusWas("Rejected")' will return TK-4
'issue in preStatusContainsAll("Open, 'In Progress'")' will return TK-3 and TK-4
'issue in preStatusContainsEither("Open, 'In Progress'")' will return TK-2 and TK-3

Note

Automating high volume queries may result in performance degradation of your Jira instance. It is recommend that the StatusWas JQL statements are used ad-hoc, and not for automation or high-volume workflow actions.

...

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 datesBeyond("1w", "Estimated Start", "Estimated 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" 
)
dateTimeWithin(
is less than or equal to "Time_Frame"
, "DateTime
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"
, "DateTime_Field_Name_2")

  • : issue due date
and any other Date Picker custom fields
JQL Example
issue in datesBeyond("1d", "Estimated Start", "Estimated End")
dateTimeBeyond
 Code Block
dateTimeBeyond("Time_Frame", "DateTime_Field_Name_1", "DateTime_Field_Name_2")
Items
ExplanationDescription
datesWithindateTimeBeyond
Return all the issues whose time difference between "DateDateTime_Field_Name_1" and "DateDateTime_Field_Name_2" is less greater than or equal to "Time_Frame"
datesBeyond
Return all the issues whose time difference between "Date
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 "Date_Field_Name_2" is greater than or equal to any other DateTime Picker custom fields
JQL Example
issue in dateTimeBeyond("1w", "created", "updated")
dateTimeWithin
 Code Block
dateTimeWithin("Time_Frame"
...
dateTimeWithin
...
, "DateTime_Field_Name_1"
...
, "DateTime_Field_Name_2"
...
)
Items
Description
dateTimeWithin
Return all the issues whose time difference between "DateTime_Field_Name_1" and "DateTime_Field_Name_2" is greater 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
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 dateTimeWithin("3d 8h", "created", "updated")
epicTree
 Code Block
...
epicTree("Epic_Issue_Key_1", "Epic_Issue_Key_2", ..., "Epic_Issue_Key_N")

Items
Description
epicTree
Return all epics with those given epic issue keys, all issues linked to those epics and all sub-tasks of those issues linked to the epics
  • at least 1 epic issue key and up to unlimited epic issue keys in JQL statement
JQL Context
issue in/not in
Arg: Epic_Issue_Key_N
Support all Jira Epic issue keys
JQL Example
issue in epicTree("Data Storage", "System Config", "Security")
FieldValueMatches
 Code Block
FieldValueMatches("Field_Name", "Regex_Pattern")
Items
Description
JQL: FieldValueMatches
Return all the issues whose specific field value matches the "Regex_Pattern"
JQL Context
issue in, issue not in
Field_Name
Support any text-based fields. i.e. "Summary", "Description", ' text field (single line)', etc.
Regex_Pattern
Support any regular expression patterns
JQL Example
issue in FieldValueMatches("summary", "[hm]at") will return all the issues whose summary contains hat or mat
issueLinkType
 Code Block
issueLinkType("Issue_Link_Type")
Items
ExplanationDescription
issueLinkType
Return all the issues that have a certain type of issue link
JQL Context
issue in/not in
Issue_Link_Type
Support all issue link types. i.e. "blocks", "is blocked by", "duplicates", "relates to" etc.
JQL Example
'issue in issueLinkType("clones")' will return all the issues whose issue link type is "clones"
...
membersOfRole
 Code Block
membersOfRole("Project_Role")
Items
ExplanationDescription
membersOfRole
Return all the issues where a specified user is in a specific project role.
JQL Context
  • creator in/not in
  • assignee in/not in
  • reporter in/not in
  • voter in/not in
  • watcher in/not in
Project_Role
Support all Jira project roles
JQL Example
assignee in membersOfRole("Administrators")
...
preStatusContainsAll
 Code Block
timeWithinpreStatusContainsAll("Time_Frame", "Status_A", "Status_B", "Status_C")
status_A, status_B, status_C,..., status_X")
Items
Description
preStatusContainsAll
Return all the issues whose historical statuses (excluding current status) include status_A and status_B and status_C and ... and status_X
JQL Context
issue in/not in
status_X
Support all Jira workflow statuses
JQL Example
Four example issues with their workflow transition history:
  1. TK-1: Open
  2. TK-2: Open → In Progress
  3. TK-3: Open → In Progress → Under Review
  4. TK-4: Open → In Progress → Under Review → Rejected → In Progress

'issue in preStatusContainsAll("Open, In Progress")' will return TK-3 and TK-4
 Note
Automating high volume queries may result in performance degradation of your Jira instance. It is recommend that the StatusWas JQL statements are used ad-hoc, and not for automation or high-volume workflow actions. 
preStatusContainsEither
 Code Block
preStatusContainsEither("status_A, status_B, status_C,..., status_X")
Items
Description
preStatusContainsEither
Return all the issues whose most recently previous status is status_A or status_B or status_C or ... or status_X
JQL Context
issue in/not in
status_X
Support all Jira workflow statuses
JQL Example
Four example issues with their workflow transition history:
  1. TK-1: Open
  2. TK-2: Open → In Progress
  3. TK-3: Open → In Progress → Under Review
  4. TK-4: Open → In Progress → Under Review → Rejected → In Progress

'issue in preStatusContainsEither("Open, In Progress")' will return TK-2 and TK-3
 Note
Automating high volume queries may result in performance degradation of your Jira instance. It is recommend that the StatusWas JQL statements are used ad-hoc, and not for automation or high-volume workflow actions. 
preStatusWas
 Code Block
preStatusWas("status_A")
Items
Description
preStatusWas
Return all the issues whose most recently previous status is status_A
JQL Context
issue in/not in
status_X
Support all Jira workflow statuses
JQL Example
Four example issues with their workflow transition history:
  1. TK-1: Open
  2. TK-2: Open → In Progress
  3. TK-3: Open → In Progress → Under Review
  4. TK-4: Open → In Progress → Under Review → Rejected → In Progress
'issue in preStatusWas("Rejected")' will return TK-4
 Note
Automating high volume queries may result in performance degradation of your Jira instance. It is recommend that the StatusWas JQL statements are used ad-hoc, and not for automation or high-volume workflow actions. 
timeBeyond
 Code Block
timeBeyond("Time_Frame", "Status_A", "Status_B", "Status_C")
Items
ExplanationDescription
timeWithintimeBeyond
Return all the issues whose sum of time spent in certain statuses is less greater than or equal to "Time_Frame"
  • At least 1 status and up to 3 statuses in the JQL statement
  • If Status_A isn't an issue's historical status, the time spent for that issue in Status_A will be 0
  • It won't return the issue if all the given statuses aren't that issue's historical statuses
JQL Context
issue in/not in
Time_Frame
Time frame can be w, d, h, m, s and separated by spaces.
  • w: week
  • d: day
  • h: hour
  • m: minute
  • s: second
Example: "1w 2d 3h 4m 5s"
status_A&B&C
Support all Jira workflow statuses
JQL Example
issue in timeBeyond("1d 2h 30s", "Open")
timeWithin
 Code Block
timeWithin("Time_Frame", "Status_A", "Status_B", "Status_C")
Items
Description
timeWithin
Return all the issues whose sum of time spent in certain statuses is greater less than or equal to "Time_Frame"
  • At least 1 status and up to 3 statuses in the JQL statement
  • If Status_A isn't an issue's historical status, the time spent for that issue in Status_A will be 0
  • It won't return the issue if all the given statuses aren't that issue's historical statuses
JQL Context
issue in/not in
Time_Frame
Time frame can be w, d, h, m, s and separated by spaces.
  • w: week
  • d: day
  • h: hour
  • m: minute
  • s: second
Example: "1w 2d 3h 4m 5s"
status_A&B&C
Support all Jira workflow statuses
JQL Example
Items
Explanation
epicTree
Return all epics with those given epic issue keys, all issues linked to those epics and all sub-tasks of those issues linked to the epics
  • at least 1 epic issue key and up to unlimited epic issue keys in JQL statement
JQL Context
issue in/not in
Arg: Epic_Issue_Key_N
Support all Jira Epic issue keys
JQL Example
issue in timeWithin("1h", "In Progress")
issue in timeBeyond("1d 2h 30s", "Open")
Linked to Epic
 Code Block
epicTree("Epic_Issue_Key_1", "Epic_Issue_Key_2", ..., "Epic_Issue_Key_N")
issue in epicTree("Data Storage", "System Config", "Security")