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 Christian Czaia

Saved on

Key

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




UI Text Box
sizemedium
typeinfo

JWT ships with three custom field types to calculate field values, display live data, or even pull data from online service providers such as Google. 

Each custom field type, from number to text, or date-time fields, comes with a different set of options that let you define exactly what you want to see as a result using the full power of the JWT expression editor.

Last but not least, you can individually define how the result of the calculation should appear, from different time formats to currency symbols, by configuring individual Display formats.


Image AddedCalculated date-time fields

This type of read-only custom field contains a value which is dynamically calculated from a custom math/time expression. It can be used to obtain a date-time value depending on the value of the current issue or in other issues.

Image AddedCalculated number fields:

This type of read-only custom field has a value which is dynamically calculated from a custom math/numeric expression. It can be used to obtain a numeric value depending on the value of other fields in the current issue or in any other issues.

Image AddedCalculated text fields

This type of read-only custom field has a value which is dynamically calculated from a custom text expression. It can be used to show a text composed from one or more field values returned by field codes.


Page properties
hiddentrue
Tech review

Status
titletodo

Style guide

Status
titletodo

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

First steps

UI Steps


UI Step

Browse to Custom fields.

After installing JWT, head over to Administration → Issues

Then browse to Custom fields

Image AddedImage Removed



UI Step

Create your first custom field

from the Custom fields admin section, head over to Add custom Field → Advanced then add the desired field offered by JWT:

Image Removed

Image Added


UI Text Box
typenote

JWT calculated fields can't be manually updated on any screen.

Therefore they won't be displayed on create, edit and transition screens, even if you added them explicitly to those screens.




Configure your custom field

UI Steps


UI Step

On the configuration screen of your newly created custom field go to Actions → Configure

Image RemovedImage Added


To add an expression click on Edit Math/Time Expression

Click on Edit Display format to configure the display format

Image Removed
UI Step

Start by adding an expression that is used to calculate the field.

Image Added

Image Added


UI Text Box
typeinfo

A non-optimized expression can cause performant problems when re-indexing, to avoid this kind of problems there are some tips to keep in mind:

  • When using field codes in the expression, if their value is null it can add some delay to the re-indexing because of the errors thrown. To avoid this it's recommendable to check with a ternary operator if the field code's value is null or not to make the calculation or not.
  • When the value depends on fields belonging to issues different from current issue, for example its linked issues or issues returned by a JQL query, problems will be faced when using it in a JQL search. This happens because its index is only updated when the current issue is updated, so the value indexed might not be updated if those different issues have not been updated, even if the value is displayed correctly. It would be necessary to re-index before executing the JQL search.



UI Step

Optionally: Customize the display format.

Image Added



UI Step

Configure the field context

Image Added


Image Added

UI Text Box
typeinfo
The field context configuration allows to decrease the number of issues in which the calculated field should be calculated and displayed, so making a good use of it will improve the performance of the field and of the re-indexing.



UI Step

Check out the result

Multimedia
namecalculated-number-field.mp4
width700



UI Text Box
typetip

To learn more about configuring the display formats, check out the following page.



UI Text Box
typetip

Been there, done that? If you need even more inspiration, make sure to check out these useful use cases that will definitely get you started.


Excerpt Include
DECADIS:Contact support
DECADIS:Contact support
nopaneltrue