Time in status custom field type

Precision

By default, durations are stored with a precision of one second. If you'd like a lower precision, you can round up values to the nearest minute, hour, day or week, which will impact how values are displayed both on individual issues and on the statistics dashboard gadgets. To round up values select the unit from the Precision field. The default is One second. 

Here are a few examples that help you in understanding further.

Example 1: If the calculated duration field evaluates to 174930 seconds, then with One-minute precision, the value is rounded off to 174960.

If the calculated duration field evaluates to 1494175 seconds which accounts to 2 weeks, 3 days, 7 hours, 2 minutes, 55 seconds or 10 weeks, 1 day, 7 hours, 2 minutes, 55 seconds (depends on the searcher) with the following precisions

Display the time spent in each status in issue detail view

In the issue detail view, the Time in status custom field displays the total time spent by the issue in any of the configured statuses. You can choose to display instead the breakdown of the time spent in each status along with the total time spent, by selecting the Time spent in each status option.

When this option is not selected, the breakdown of the time spent in each status is displayed when the user hovers over the custom field value.

Display the time spent in each status in the list view

In the issue list view, the Time in status custom field displays the total time spent in any of the configured statuses by the respective issue. You can choose to display instead the breakdown of the time spent in each status along with the total time spent, by selecting the List View Time spent in each status option.

Search template

When creating a Time in status custom field type, you can configure the Search template as 

• Duration searcher (24x7 durations) - Allows searching for a duration. Durations are considered as calendar durations. Supports Statistics Gadgets.
• Number range searcher - Allows searching for a number that is in a given range.

Using these searchers you will be able to search for issues within a range of values for that custom field. The default search template is Duration searcher (24x7 durations). If you select “None”, then you won’t see any reference to this field in the Issue Navigator search fields. Note that changing a custom field searcher requires a re-index. 

Duration searcher (24x7 durations) is a custom statistics compatible searcher provided by JMCF that allows Duration type custom fields of JMCF to be used in the statistics gadgets. See here for more information. 

Specify the status(es) to look for

To specify the status(es) to look for:

1. Locate the custom field on the Custom Fields administration page.
2. Click on the cog wheel and click on Configure
3. Click on Edit Status(es).
4. Select the status(es).
5. Click on Save.

To remove the status(es) to look for:

1. Locate the custom field on the Custom Fields administration page.
2. Click on the cog wheel and click on Configure
3. Click on Edit status(es) to look for.
4. Uncheck the status(es) you wish to remove.
5. Click on Save.

Customize the formatting of the Time in status custom field value

For a Time in status field, the Search Template also determines how durations are displayed, and how duration strings returned by the formula are parsed. By default, the search template is Duration searcher (24x7 durations). However, you can customize it by changing the Search template. When you select the template,

• Duration searcher (24x7 durations), the duration is displayed in general duration format, where a day has 24 hours. For example, 144000 seconds is displayed as 1day, 16hours.
• Number of seconds, the duration is displayed as a number in a Long format representing the number of seconds.
• None, the duration is displayed in general duration

Customize the display of the Time in status custom field value on issue detail view

You can define a velocity template that will return the Html representation of the calculated custom field on issue detail view. Leave it empty to use the default template. 

To select a format for a Time in status custom field type value;

1. Locate the custom field on the Custom Fields administration page.
2. Click on the cog wheel and click on Configure
3. Click on Edit Velocity Template.
4. Input the template.
5. Click on Save.

You can use the following Velocity variables in the template:

• $value: the raw field value, the number of seconds
• $formattedValue: the field value formatted according to the field configuration above
• and other variables described on this page

For example:

<div style="border: dashed">
  $formattedValue
</div>

<div style="border: dashed">
  $formattedValue
</div>