NEW IN JMCF 2.0.0
Adding a Calculated Duration custom field type
To add a Calculated Duration custom field type to your instance:
- Log in to JIRA as an administrator.
- Go to the Administration icon and click on it.
- Click on
Issues - > Custom fields.
- Click on
Add custom field
. - Click on
Advanced
in the left panel. - Locate
Calculated Duration Field type
and select it. - Click on
Next
. - Provide a name for the custom field.
- You can optionally provide a description for the custom field.
- Click on
Create.
- Associate the custom field to the appropriate screens.
- Locate the custom field in the Custom fields administration page and click on the cog wheel.
- Click on
Configure
and create a formula (explained below) for the field. - You can create multiple contexts if you need to associate different formulas with particular projects or issue types.
- Perform a re-index as prompted by JIRA.
Search template
When creating a Calculated Duration custom field type, you can configure the Search template as Duration searcher (using Time Tracking settings)
or Number range searcher
to be able to search for issues within a range of values for that custom field. If you select “None” for the searcher, 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.
Configuring the Groovy formula for a Calculated Duration custom field type
To write a formula for the Calculated Duration custom field type;
- Locate the custom field on the Custom Fields administration page.
- Click on the cog wheel and click on
Configure
- Click on
Edit Groovy Formula
- In the editor write a Groovy script that returns a duration String or a number in a Long format representing the number of seconds. Also, you can test your script against any issue using the Groovy script tester.
- Click on
Save.
As documented on the Expected Value tab of the Groovy editor help, the Groovy formula must return either:
- A number in a Long format representing a number of seconds (e.g.
3600
) - A String representing a duration in Jira duration format (e.g.
"1w 3d 5h"
)
Examples of Groovy formula for a Calculated Duration custom field:
A Groovy expression returning a number in a Long format representing a number of seconds:
144000L
A Groovy expression returning a duration String
"3w 2d"
A Groovy expression returning the "Original estimate" of the issue:
issue.get("originalestimate")
A Groovy expression adding a week time to the Time Spent on the issue
if(issue.timespent){ return issue.timespent + 144000 } else{ return null }
A Groovy expression that returns the duration from issue creation to now. The difference between two date objects returns the number of days and hence you need to convert it into seconds since the calculated field expects a number of seconds
return (new Date() - issue.created)*24*60*60
Customizing the formatting of the Calculated Duration custom field value
By default, the Calculated Duration custom field type value is displayed in Duration format. However, you can customize it.
To select a format for a Calculated Duration custom field type value;
- Locate the custom field on the Custom Fields administration page.
- Click on the cog wheel and click on
Configure.
- Select a format from the
Duration format
drop-down. - Click on
Save.
The available formats are:
Duration: The calculated field duration is displayed in the general duration format, where a day has 24 hours. For example, 144000
seconds is displayed as 1day, 16hours
Duration (Time Tracking Format): The calculated field duration is displayed as configured in Jira settings, where a day has 8 hours by default and a week has 5 days. For example, 144000
seconds is displayed as 1w
Number of seconds: The calculated field duration is displayed as a number in a Long format representing the number of seconds.
Customizing the display of the Calculated Duration custom field value
You can also define a velocity template that will return the Html representation of the calculated custom field. Leave it empty to use the default template.
To write a velocity template for a Calculated Duration custom field type value;
- Locate the custom field on the Custom Fields administration page.
- Click on the cog wheel and click on
Configure
- Click on
Edit Velocity Template
. - Input the template.
- Click on
Save.
You can use the following Velocity variables in the template:
$value
: the raw field value, a Long value representing a 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>
displays the formatted value of the field with a dashed border.
#if( $value > 2 ) <font color= "red"> <b> Delayed by $formattedValue </b> </font> #else <font color= "blue"> Delayed by $formattedValue </font> #end
Displaying the Calculated Duration custom field on Transition and Edit screens
The Never show on Transition and Edit screens
option controls whether the calculated Duration custom field can appear on transition and edit screens. If you select this option, the field will not be visible on any Edit or Transition screen, even if it is added to the screen.
Accessing the Calculated Duration custom field type from other Groovy scripts
You can access this field using any of the following getters of the Issue interface
get("Your custom field name") or get("customfield_xxxxx")
that returns a number in a Double format.getAsString("Your custom field name")
or
getAsString("customfield_xxxxx")
that returns aString
representing the duration in number of seconds