Versions Compared

Key

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

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...


Excerpt
hiddentrue
Calculates time spent within during the selected configured status(es) according to based on the defined working calendar

(version 5.26.0+)

Time in Status (Status Timer) custom field lets you track time spent in selected status(es). It can be configured to work against a specific working calendar.

Field simply displays total time passed within during the selected status(es) as below

Image RemovedImage Added

When clicked, it displays all details, below is a snapshot to clarify

Image RemovedImage Added

Creating Time in Status custom field

To define Status Timer custom field:

  • Navigate to JIRA Admin > Add-ons > Enhancer Plugin Menu > Custom Field Configuration and switch to Duration fields tab.
  • Click on Add new Status Timer custom field link button. 
    Image Removed
    Image Added
  • Fill the dialog
    Image RemovedImage Added
    1. Give a Name to your custom field
    2. Select the status(es) that you want to see time spent in.
    3. Calendar can be selected. Working calendars can be defined in JIRA Admin > Add-ons > Enhancer Plugin Menu > Working Calendars menu item.
    4. Occurrence can be set to display only "First" or "Last" occurrence, or aggregated result with "Cumulative" option

    5. Configure Time formatter display options (both for issue main view and navigator view)
  • And click Add Custom Field or Update button. That's it.

Don't forget to associate custom field to appropriate screens in order to see them.

Searching with Time in Status custom field

Time in Status (Status Timer) custom field comes with a powerful searcher. You can use this custom field in your JQL statements in order to filter issues by status, then assigned users.

timeSpentBy(), timeSpentInStatus() and timeSpentInStatusBy() JQL functions can be used as right hand functions with the custom field.

Below there are some samples:


  • Searching against total duration including every users within the selected status(es).
    "Time in Review" >= 4d

  • Searching against a single user. 
    "Time in Open" <= timeSpentBy("5d", "agrant")

  • Searching against multiple users. Below function searches time spent by users (agrant, jevans and hjennings) in 'Waiting for support status' more than 5 calendar days.
    "Time in Waiting for support" >= timeSpentBy("5d", "agrant", "jevans", "hjennings")
  • Searching by the IDs of status(es) . When the custom field is defined with multiple statuses, but you want to filter by some of them with the status IDs.

    "Time in Open" > timeSpentInStatus("2d", "1") 

    (where 1 is ID of status Open)

  • Searching by the names of the status(es). When the custom field is defined with multiple statuses, but you want to filter by some of them with the status names.

    "Time in In progress" >= timeSpentInStatus("6h", "In Progress") 
    "Time in In progress" >= timeSpentInStatus("6h", "Open", "In Progress", "In Review")
  • Searching by status ID and the users

    "Time in In progress" > timeSpentInStatusBy("8h", "3", "agrant") 
    (where 3 is ID of status Open and agrant is the username)
  • Searching by status name and the users

    Test > timeSpentInStatusBy("10h", "Open", "hjennings")