Versions Compared

Key

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

...

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.

timeWithin

timeBeyond

Code Block
timeWithin("Time_Frame", "Status_A", "Status_B", "Status_C")
timeBeyond("Time_Frame", "Status_A", "Status_B", "Status_C")

Items

Explanation

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

Explanation

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

issue in timeWithin("1h", "In Progress")issue in timeBeyond("1d 2h 30s", "Open")