Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Page properties
hiddentrue
Tech review

Status
colourGreen
titledone

Style guide

Status
colourGreen
titledone

Page status

Status
colourGreen
titledone

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

UI Text Box
sizemedium
typeinfo

Use case

This calculated field returns thedifference between the current date and the earliest due date among the issue's sub-tasks.

Configuration

UI Steps
UI Step

Create a new Calculated Number Field (by JWT) custom field and name it properly.

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 parser expression:

Code Block
languagebash
titleMath expression for Calculated number field:
linenumberstrue
min(fieldValue({issue.dueDate},subtasks())) - {system.currentDateTime}
UI Step

Display format

UI Steps
UI Step

Content type

Choose Duration

UI Step

Duration display format

Choose Long

UI Expand
titlemore info...
UI Text Box
typeinfo

For this use case the format duration was chosen since the numeric value is being calculated, a number of milliseconds represents a time duration.

This way the value is represented like 2d 9h 43m instead of a single number.

UI Step

Check the parameter Use time tracking settings

UI Expand
titlemore info...
UI Text Box
typeinfo

By checking this parameter, the duration will be based on the number of working hours per day, and the number of working days per week as configured in time tracking, instead of 24 hours per day and 7 days per week.

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, the result will look like this:



Related use cases

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


Excerpt Include
DECADIS:Contact support
DECADIS:Contact support
nopaneltrue

Page properties
hiddentrue
JWT feature

Field typeNumber
Parser functions

min()

fieldValue()

subtasks()

Label