...
...
| hidden | true |
|---|
...
...
| Panel | ||||||||
|---|---|---|---|---|---|---|---|---|
| ||||||||
This page is about JEP for Jira DC. Using Cloud? Click here. |
The Time in Status
...
custom field is a powerful tool for tracking the duration that issues spend in specific statuses within your Jira instance. It provides granular insights into workflow efficiency, identifies bottlenecks, and supports data-driven decision-making. It can be configured to work against a specific working calendar.
...
It displays the total time passed during the selected status(es)
...
.
...
When clicked, it displays all
...
Creating the Time in Status Custom Field
To define the Time in Status Custom Field:
...
the details:
On this page:
|
|---|
Step 1: Create a Time in Status custom field
From Jira settings, navigate to Manage Apps.
From the side menu, find
Enhancer Plugin for JIRA.Click Custom Field Configuration.
Click on theAdd New JEP custom field button.
Click the Duration tab on the left-hand side of the dialogue.
Select Time in Status, then click Add custom field.
...
Step 2: Configure the field
Fill in the dialog box
...
that appears.
...
...
Name – Provide a descriptive name for the custom field.
Status(es) – Select the status(es) that you want to calculate the amount of time spent in.
...
Working calendar – Choose a working calendar (defined in Jira Admin >
...
The Occurrence can be set to display only the "First" or "Last" occurrence, or an aggregated result with a "Cumulative" option.
...
Manage apps >
ENHANCER PLUGIN FOR JIRA> Calendars) to calculate time based on specific work hours.Occurance – Specify whether to display the first, last, or cumulative occurrence of the status.
Grouping field – Determine the field by which the time in status details are grouped (e.g., Assignee, Project).
Time format – Configure the display options (both for the issue main view, navigator view, and board view)
...
. The Use Separator
...
lets you
...
define your own separator for the time
...
display. You can also choose to not have a separator.
...
Click the Save custom field button.
| Tip |
|---|
You must link the custom field with the appropriate screens |
...
to see them. |
...
You can always configure or delete the custom field by simply clicking on the cog icon on the right-hand side.
...
For more information, refer to the Jira documentation. |
Usage in JQL searches
The Time in Status Custom Field comes with a powerful searcher. You can use this custom field in your JQL statements
...
to filter issues by status
...
and then by 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.
Below are some examples:
Searching against total duration including every
...
grouping field value within the selected status(es)
...
:
Code Block "Time in Review" >= 4dSearching 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
...
groups.
...
The below function searches time spent by
...
the 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", "
...
jira-developers", "
...
jira-users ", "
...
jira-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 the ID of the 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
...
grouping field value:
Code Block "Time in In progress" > timeSpentInStatusBy("8h", "3", "agrant")(Where 3 is the ID of the 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).
| Excerpt | ||
|---|---|---|
| ||
Calculates the time spent during the configured status(es) based on the defined working calendar. |