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 25

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.


pipe

Page properties
hiddentrue
Calculated field typedate-time
Use case descriptionComplexity
Panel


Tech review

Status
colourGreen
titledone

Style guide

Status
colourGreen
titledone

Page status

Status
colourGreen
titlecomplete

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

On this page

Table of Contents
exclude(On this page|Use case).*
stylecircle
typeflat
separator



UI Text Box
sizemedium
typeinfo

Use case

The prediction of the completion date of an epic is very useful for reporting and planning purposes. 

This use case calculates the predicted completion date based on cumulated remaining estimates of all issues linked to each epic.

To calculate the remaining estimates, a second calculated field will be used, which is explained in this use case: Total remaining estimate in an epic (all linked issues)


Image AddedConfiguration

UI Steps


UI Step

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

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
addTimeSkippingWeekends(%{00057system.currentDateTime}, {10200issue.cf10200}*{DAY}, LOCAL, {FRIDAY}, {SATURDAY})


ui-expand
titlemore info...


UI Text Box
typeinfo

{

00057

issue.cf10200}

is

 is the field code for

Current date and time
  • {10200} is the field code for custom field Epic Remaining

    • the calculated field Epic Remaining. See this use case on how to calculate this value: Total remaining estimate in an epic (all linked issues)

    Additionally to the JWT calculated number field this example uses the addTimeSkippingWeekends() function.




    UI Step


    UI Steps

    Display Format

    UI Step

    Click on Edit Display Format to configure the display format

    UI Step

    Choose Date Time Picker for Format type

    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
    UI Step

    Check the results

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




    Image Added Related use cases

    Page properties report
    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

    Image Added

    Field typeDate-time
    Parser functionsaddTimeSkippingWeekends()
    Label

    Status
    colourRed
    titlestaff pick