Get started

Use case library

JWT expression editor

JWT expression parser functions

JWT workflow functions

JWT remote actions

JWT automation rules

JWT calculated fields

JWT calendars

JWT properties

JWT JQL functions

Cloud migration hub

Additional product info

Versions Compared

Old Version 22

changes.mady.by.user Thorsten Letschert

Saved on

compared with

New Version 23

changes.mady.by.user Christian Czaia

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


Page properties
hiddentrue


Tech review

Status
colourYellow
titleReady for review

Style guide

Status
colourGreen
titledone

Page status

Status
colourRed
titlenot complete
Screenshots

Status
titletodo
Status
colourYellow
titleReady for review
Status
colourGreen
titledone
Status
colourRed
titleflagged



UI Text Box
sizemedium
typeinfo

Use case

This calculated field will return the predicted resolution date of the issue by adding the remaing estimate to the current date and taking business hours into consideration.

To do soachieve this, a calendar is used to specifiy the actual business hours.


Configuration

UI Steps


UI Step

Create a new Calculated Date-Time Field (by JWT) custom field and name it appropriately.

UI Text Box
typetip

Providing a description will help you to identify what the custom field does, but this step is optional.



UI Step

Parser expression

Add the following expression:

Code Block
languagebash
titleDate/Time expression for Calculated date/time field:
linenumberstrue
{issue.remainingEstimate} != null ? addTime({system.currentDateTime},({issue.remainingEstimate} * {MINUTE}), "businessHours", LOCAL) : null


UI Expand
titlemore info...


UI Text Box
typeinfo

businessHours is the the JWT calendar used to specifiy the actual business hours. In this example we will assume a simple eight-hour working day:

Code Block
languagebash
titleCalendar expression for 'businessHours':
linenumberstrue
MON-FRI {
   08:00-16:00;
}





UI Step


UI Steps

Display Format

UI Step

Format type

Choose Date Time Picker




UI Step

Add the field to the relevant view screens.

UI Text Box
typenote

Remember: All calculated fields are read-only and cannot be manually updated on a create or edit screen.



UI Step

Check the results

Once configured and added to an issue screen (e.g. for all stories), the result will look like this:

SCREENSHOT




Related use cases

Page properties report
firstcolumnUse case
headingsField type, JWT feature, Label
sortByTitle
cqllabel = "calculated-field" and space = "JWTSDC" and ancestor = "27068727"

Excerpt Include
DECADIS:Contact support
DECADIS:Contact support
nopaneltrue


Page properties
hiddentrue


JWT feature

Field type

Date-time

Label



...