Time in status - JQL (common)

Functions take the following parameters.

  • jql - a string with a valid search query. For example: “Project = TEST and created < startOfWeek()”
  • statuses - the name or id of the statuses, separated by commas. For example: “Open” or “Open, 10000, 10001”.
  • condition - one of the characters <, <=, => =,>. For example: “>”.
  • time - time string corresponding to one of the patterns.
"5h35m12s" - 5 hours 35 minutes 12 seconds
"5h12s" - 5 hours 12 seconds
3000m - 3000 minutes
"0", "0s" ... - time is zero.

Common functions.

General functions work without reference to the “Time in status” field.

  • issue in timeInStatus (“statuses”, “condition”, “time”)
  • issue in timeInStatusByJql (“jql”, “statuses”, “condition”, “time”)
  • issue in timeInStatusByJqlAndWokCalendar (“jql”, “statuses”, “condition”, “time”, “calendar”)

Or their replacement counterparts, in case of functions of the same name in other plugins.

  • issue in timeInStatus_jb (“statuses”, “condition”, “time”)
  • issue in timeInStatusByJql_jb (“jql”, “statuses”, “condition”, “time”)
  • issue in timeInStatusByJqlAndWokCalendar_jb (“jql”, “statuses”, “condition”, “time”, “calendar”)

If you want to use both plugins, go to “Manage Plugins”, then expand the modules for either plugin, and selectively enable or disable the JQL function modules for those functions. For example, in “Time in status”, the module providing jql-functions is displayed as:

issue in timeInStatus (“statuses”, “condition”, “time”)

  • Returns tasks that spent a certain time in the indicated statuses.
  • The function works in real time.
  • The function takes tasks matching the query “status was in (statuses)” and additionally filters them by condition.

issue in timeInStatusByJql (“jql”, “statuses”, “condition”, “time”)

  • It returns tasks from the jql request that spent a certain time in the indicated statuses.
  • The function works in real time.
  • The fewer jql tasks the faster the function works.

issue in timeInStatusByJqlAndWokCalendar (“jql”, “statuses”, “condition”, “time”, “calendar”)

  • It returns tasks from the jql request that spent a certain time in the indicated statuses. Calculation of time is done according to the specified calendar.
  • The function works in real time.
  • The fewer jql tasks the faster the function works.

Examples

  • issue in timeInStatus (“NEW”, “>”, “1h”)
  • issue in timeInStatus (“10000”, “>”, “1h”)
  • issue in timeInStatus (“10000, 10001”, “<”, “1h5m”)
  • issue in timeInStatusByJql (“project = TEST”, “10000, 10001”, “<”, “1h5m”)

Calendar field
Time in status - field configuration
JiBrok message field Message field
JiBrok time in status Time in status | SLA | Timer | Stopwatch
Tutorials
Settings
Work calendars
Time in status
Timers and Stopwatches
Stopwatch
Timer
Additional functions
Issue panels
Reports
Field Helpers
Other fields
API
Reference information
JiBrok Switch to User + Delegating SU (Jira) Switch to User + Delegating SU (Jira)
JiBrok time in status Time in status for Jira Cloud
Work calendars
Time in status fields
Issue panels
Reports
Service tools
Reference information
JiBrok Calculated fields Calculated fields (JBCF)
JiBrok Calculated fields Calculated fields (JBCF) for Jira Cloud
JBCF fields
Service tools
JiBrok Timer Timer field | SLA for Jira Cloud
Work calendars
Timer fields
Issue panels
Service tools
JiBrok Stopwatch Stopwatch for Jira Cloud
Work calendars
Stopwatch fields
Issue panels
Service tools
JiBrok Time between dates Time between dates for Jira Cloud
Time between dates fields
JiBrok Fields panel for Jira Service Management (JSM) Fields panel for Jira Service Management (JSM)
JiBrok Display Linked Issues Display Linked Issues
User helper for JiBrok cloud apps User helper for JiBrok cloud apps