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 6

changes.mady.by.user Iheb Kharab

Saved on

compared with

New Version Current

changes.mady.by.user Iheb Kharab

Saved on

Key

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


style

Page properties
hiddentrue


Tech review

Status
colourYellowGreen
titleReady for reviewdone

Style guide

Status
colourYellowGreen
titleReady for reviewdone

Page status

Status
colourRedGreen
titlenot completedone
Screenshots

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

Panel

On this page

Table of Contents
maxLevel2
exclude(On this page|Use case).*

circletypeflatseparatorpipe



UI Text Box
sizemedium
typeinfo

Use case

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

To achieve this, a calendar is used to specify the actual business hours.


Image AddedConfiguration

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}), "working-hours", LOCAL) : null


UI Expand
titlemore info...


UI Text Box
typeinfo

working-hours is the JWT calendar used to

do

specifiy the actual business hours. In this example we will assume a simple eight-hour working day:

Code Block
languagebash
titleCalendar expression for 'working-hours':
linenumberstrue
MON-FRI {
   08:00-17:00;
}





UI Step


UI Steps

Display Format

UI Step

Click on Edit Display Format to configure the display format

UI Step

Format type

Choose Date Time Pickeras Format type




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:

Image Added

SCREENSHOTImage Added




Image Modified Related use cases

Page properties report
firstcolumnUse case
headingsField type, Use case description, ComplexityJWT 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

Image Added

Field type

Date-time

Parser functionsaddTime()
Label