Page Comparison

Search template:

When creating a calculated date/time custom field type, you can configure the Search template as Date range picker to be able to search issues within a date/time 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 date/time type custom field

To write a formula for the custom field;

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 Groovy Formula
4. In the editor write a Groovy script that returns a java.util.Date. You can test you written script against any issue using the Groovy script tester.
5. Click on Save.

Some examples of a Groovy formula:

• A simple String representing a timestamp in the format specified in your Jira system settings. For example:

  Code Block
  language groovy linenumbers true
  "11/Apr/17"

  
  

• A Groovy expression that returns returning a java.util.Date

  Code Block
  language groovy linenumbers true
  new Date()

  
  

• A Groovy expression to reference that references any field of the issue that returns a Timestampjava.util.Date

  Code Block
  language groovy linenumbers true
  issue.get("created")

  
  

• A Groovy expression that includes arithmetic operators as well as any other Groovy operator, and Groovy method calls

  Code Block
  language groovy linenumbers true
  issue.get("created") + 5
  Code Block
  language groovy linenumbers true
  issue.get("duedate").format("YYYY/MM/DD")

  
  

Customizing the display of the calculated date/time custom field type value

By default, the calculated date/time field value is displayed using Jira's default date format (if you leave the Edit date format to Default). However, you can customize it using Groovy. To configure select a format for a calculated date/time 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 Date Format Expression.

4. In the editor write a Groovy script to format the value returned by the Groovy formula (see above). 
5. You can test you written script against any issue using the Groovy script tester.
6. Click on Save.

The Groovy script must return a String containing HTML markup. 

Example 1

Consider an example where you want to calculate the amount to be paid in dollars for the Time Spent on the issue. For this, you will need to first calculate the amount to be paid and then format it using the numberTool to display it as a currency.

Groovy formula:

(issue.get("timespent") / 60 / 60) * 20

Groovy format:

numberTool.format('currency',value)

If the Time Spent on the issue is 7200 seconds, the Groovy expression will return the number 40 and it will be formatted to $40.

Example 2

Consider another example where you want to display an icon to the left of the field value depending on the field value. For this, you will need to format the value returned by the Groovy formula using the numberTool and add an IMG tag to display an icon to the left of the number.

Groovy format:

if (value > 21)
  return "<img src='/images/icons/priority_trivial.gif'> "+numberTool.format(value);
else if (value >= 10)
  return "<img src='/images/icons/priority_major.gif'> "+numberTool.format(value);
else
  return "<img src='/images/icons/priority_blocker.gif'> "+numberTool.format(value);

Image Removed

1. Select a format from the Date format drop-down.
2. Click on Save.

Customizing the display of the calculated date/time custom field type value in the List views

By default, the calculated date/time field value is displayed using Jira's default date format (if you leave the Edit Date Column Format to Default) in the List views. However, you can customize it. To select a format for a calculated date/time custom field type value in the List views;

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 Date Column Format.

4. Select a format from the Date format drop-down.
5. Click on Save.

For example if you select COMPLETE option in the Edit Date Format/Edit Date Column Format, and the value returned by the Groovy formula is Thu Jan 25 15:20:34 IST 2018, then the value will be formatted to 25/Jan/18 3:20 PM.