Versions Compared

Key

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


Excerpt
hiddentrue
Calculates the time spent during the configured status(es) based on the defined working calendar.

...

  • Navigate to Jira Admin > Manage Apps > Enhancer Plugin For Jira Menu > Custom Fields (JEP).
  • Click on the Image Modified button.
  • Click on the Duration tab on the left-hand side of the dialogue. 
  • Select Time in Status, then click Add custom field.
  • Fill in the dialog box:
    Image Removed
  • Image Added
    • Create a Name for your custom field.
    • Select the status(es) that you want to calculate the amount of time spent in.
    • A Calendar can also be selected. Working calendars can be defined in Jira Admin > Add-ons > Enhancer Plugin Menu > Working Calendars menu item.
    • The Occurrence can be set to display only the "First" or "Last" occurrence, or an aggregated result with a "Cumulative" option.

    • The Grouping Field is the field by which the Time in Status's details are grouped. It is set to Assignee by default.
    • Time formatter display options (both for the issue main view, navigator view, and board view) can be configured easily as below. 
    • The Use Separator allows you to define your own separator for the time formatter display. You can also choose to not have a separator.
      Image RemovedImage Added
  • And click the Save Custom Field button. That's it.

...

You can always configure or delete the custom field by simply clicking on the cog icon on the right-hand side.
 Image Modified

Searching with the Time in Status Custom Field

The Time in Status 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 usersby the value of the Grouping Field of your choice.

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

...

  • Searching against total duration including every user grouping field value within the selected status(es).

    Code Block
    "Time in Review" >= 4d


  • Searching against a single user.

    (In this example, the grouping field could be set to "Assignee") 

    Code Block
    "Time in Open" <= timeSpentBy("5d", "agrant")



  • Searching against multiple usersgroups. Below function searches time spent by users (agrant, jevans and hjenningsthe groups (jira-developers,jira-users and jira-administrators) in 'Waiting for support status' for more than 5 calendar days.

    (In this example, the grouping field could be set to a group picker custom field)

    Code Block
    "Time in Waiting for support" >= timeSpentBy("5d", "agrantjira-developers", "jevansjira-users ", "hjenningsjira-administrators")



  • 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.

    Code Block
    "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.

    Code Block
    "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 usersgrouping field value.

    Code Block
    "Time in In progress" > timeSpentInStatusBy("8h", "3", "agrant") 


    (Where 3 is ID of status Open, the grouping field is "Assignee", and agrant is the username).

  • Searching by status name and the users.

    Code Block
    "Backlog time" > timeSpentInStatusBy("10h", "Open", "hjennings")

    (Where the grouping field is set to a single user picker and hjennings is the username).