Versions Compared

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
colourYellow
titleReady for review

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


Page properties
hiddentrue


Field typeJWT calculated date-time fields
Use case descriptionDisplays the creation date-time of the linked epic.
Complexity

Status
colourGreen
titleBeginner




Panel

On this page

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



UI Text Box
sizemedium
typeinfo

Use case

Count This calculated field returns the number of subtasks sub-tasks, which are open (in status category To Do or In Progress).


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

Code Block
languagebash
titleMath expression for Calculated Number field:
linenumberstrue
count(filterByPredicate(subtasks(), ^%{00144issue.statusCategory} = "To Do" OR ^%{00144issue.statusCategory} = "In Progress"))


Expand
titlemore info...


UI Text Box
typeinfo
  • %{00144} is the field code for Status Category
  • The ^ is used for referencing the seed field values of the issue list l  - in this case, subtasks(). Without, the the field codes function would refer to the current issue.
    [Schema for function filterByPredicate(issue list l, boolean expression predicate)]

To achieve this, the following functions are used:




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

Once configured and added to an issue screen (a parent issue ), the result will look like this:




Image AddedRelated use cases

Page properties report
firstcolumnUse case
headingsField type, Use case description, Complexity
sortByTitle
cqllabel = "calculated-field" and space = "JWTSDC" and ancestor = "27068727"


Excerpt Include
DECADIS:Contact support
DECADIS:Contact support
nopaneltrue