Our new Appfire Documentation Space is now live!

Take a look here! If you have any questions please email support@appfire.com

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

A Calculated Date/Time custom field type returning a java.util.Date (which represents a date+time). It is a read-only field that returns the result of the evaluation of a formula.

Adding a Calculated Date/Time custom field type

To add a Calculated Date/Time custom field type to your instance:

  1. Log in to JIRA as an administrator.
  2. Go to the Administration icon  and click on it.
  3. Click on Issues - > Custom fields.
  4. Click on Add custom field.
  5. Click on Advanced in the left panel.
  6. Locate Calculated Date/Time Field type and select it.
  7. Click on Next.
  8. Provide a name for the custom field
  9. You can optionally provide a description for the custom field.
  10. Click on Create
  11. Associate the custom field to the appropriate screens.
  12. Locate the custom field in the Custom fields administration page and click on the cog wheel.
  13. Click on Configure and create a formula (explained below) for the field.
  14. You can create multiple contexts if you need to associate different formulas with particular projects or issue types.
  15. Perform a re-index as prompted by JIRA.
On this page

Related links


If you have upgraded from JMCF 1.x to 2.x please refer to the upgrade guide.

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 custom field type

Starting from 2.0.0 BeanShell has been replaced by Groovy in the JMCF add-on. Scripts written in BeanShell will work unchanged in Groovy except for some specific cases.

To write a formula for the Calculated Date/Time custom field type;

  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 Groovy expression returning a java.util.Date. For example returning the current date/time

    new Date()

  • A Groovy expression that references any field of the issue that returns a java.util.Date. For example, storing the issue updated date/time.

    issue.get("updated")

  • A Groovy expression that includes arithmetic operators as well as any other Groovy operator, and Groovy method calls. For example, adding a specific number of days to the issue creation date.

    issue.get("created") + 5

Make sure that the formula returns either a java.util.Date or a String representing a Date or null. You can test your written scripts against any issue using the Groovy script tester.

Customizing the display of the Calculated Date/Time custom field type value

By default, the Calculated Date/Time custom field type value is displayed using Jira's default date format (if you leave the Date Format to Default). However, you can customize it. To 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.

  4. Select a format from the Date format drop-down.
  5. 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 custom field type value is displayed using Jira's default date format (if you leave the Date Column Format to Default) in the tabular 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 the 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.

  • No labels