🚀 JWT 3.0 is out 🚀 

The app was completely overhauled, and so was the documentation: Jira Workflow Toolbox (Server/Data Center) Home

The page you are viewing is still valid for all app versions prior to 3.0.

This function has been renamed with the JWT 3.0 release. 

Find the new documentation at:

Mathematical or date-time expression calculator

On this page


Purpose

This post-function allows to do almost any math and time calculation you can imagine using any system or custom field values, in current issue or any other related issue (linked issue, sub-tasks, JQL selected, etc). This feature uses the Expression Parser.



Example 1: Set field using fields on linked issues and sub-tasks

In this example we set custom field "Story Points" in our Epic with the sum of values of custom field "Story Points" in related stories and sub-tasks:


Note that:

  •  {10025} is code numeric value of "Story Points" custom field in the particular Jira instance of this example

Once configured, post-function looks like this:




Example 2: Date-Time Calculation

Time calculations are made based on the fact that Date and Date-Time system or custom fields return the number of milliseconds elapsed since January 1, 1970, 00:00:00 GMT.

Let's see how to calculate the number of whole days elapsed since issue creation:


Note that:

  • {00057} is code for numeric value of "Current date and time"
  • {00009} if code for numeric value of "Date and time of creation"

Once configured, post-function looks like this:


Examples of Math and Time Expressions