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
Automated actionUse case description

 Calculate field values from all sub-tasks and writes the sum into a corresponding field in the parent issue.  

Complexity

Status
colourGreen
titleBeginner

Panel

On this page

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

StatuscolourRedtitleMaybe we should also create an example with a calculated number field and link them



UI Text Box
sizemedium
typeinfo

Use case

When a custom "Number field" is changed in a sub-task, a corresponding field in the parent issue, representing the sum of those field values, will be automatically updated.

The rule executes every time the field is being updated on a sub-task.


UI Text Box
typetip

Don't want to use an automation rule? Just take a look at JWT calculated number fields instead!




UI Steps

Image ModifiedField

Changed Event

changed event

UI Step

Excerpt Include
DECADIS:Automation Use Case - Create Rule Step
DECADIS:Automation Use Case - Create Rule Step
nopaneltrue


UI Step

Add a Trigger → Field Changed Eventchanged event

UI Steps


UI Step

Fields

*

Choose your custom Number Field


UI Step

Changed to

*

Choose Any value



Image ModifiedIssue

Selector

selector

UI Step

Add SelectorIssue Selectorselector


UI Step

Target Issue(s)

*

Choose Parent Issue

Image Modified Update

Field

field action

UI Step

Next to the Issue Selector click on Add → ActionUpdate Fieldfield

UI Steps


UI Step

Field

*

Choose your custom Number Field


UI Step

Update to

* 

Choose Value returned by parsed expression


UI Step

Parser Expression

*

Set the mode to Advanced text and enter the following Parser Expression

Code Block
languagebash
linenumberstrue
sum(fieldValue({issue.cf11502}, subtasks())) 
#Replace field code with the field code of your custom field. Use the field dropdown to automatically insert the field code


UI Text Box
typenote

cf11502  {issue.cf11502} is the field code for the custom number field to be summed up. The field code will differ in your instance.





UI Step

Excerpt Include
DECADIS:Automation Use Case - Enable Rule
DECADIS:Automation Use Case - Enable Rule
nopaneltrue




Image ModifiedScreencast

This is how the configuration above should look on your screen.

Multimedia
nameupdate_summed_up_value_in_parent_issue_on_field_changed_in_sub-task.mp4
width700

UI Text Box
typetip

You can get the same result by configuring JWT calculated number fields.



Image ModifiedImport the example

Import the JSON file below to get started in no time.


UI Expand
titleJSON


UI Text Box
typewarning

After importing the JSON file, make sure to check the configuration of the rule. Non-existing configuration elements (issue types, fields, values etc.) will be highlighted.


Code Block
languagejs
themeMidnight
linenumberstrue
{
    "name": "Update summed up value in parent issue on field change in sub-tasks",
    "description": "",
    "creator": "admin",
    "status": true,
    "triggerData": "",
    "triggerType": "FIELD_CHANGED_EVENT",
    "configuration": {
        "refs": [
            "issue",
            "system",
            "trigger.issue",
            "trigger.parent"
        ],
        "fieldId": "12202",
        "option": "any",
        "triggerType": ""
    },
    "children": [
        {
            "sequence": 0,
            "type": "ISSUE_SELECTOR",
            "ruleEntityType": "SELECTOR",
            "configuration": {
                "refs": [
                    "issue",
                    "project",
                    "system",
                    "trigger",
                    "trigger.issue",
                    "trigger.parent"
                ],
                "option": "parent",
                "issueListExpressionParsingMode": "issues",
                "actingUser": "field_00020"
            },
            "children": [
                {
                    "sequence": 0,
                    "type": "UPDATE_FIELD",
                    "ruleEntityType": "ACTION",
                    "configuration": {
                        "refs": [
                            "issue",
                            "issues",
                            "project",
                            "selector.issue",
                            "selector.parent",
                            "system",
                            "trigger",
                            "trigger.issue",
                            "trigger.parent"
                        ],
                        "fieldId": "12202",
                        "mode": "parser",
                        "value": "sum(fieldValue({issue.cf12202}, subtasks()))",
                        "valueParsingMode": "math",
                        "sendMail": "true",
                        "actingUser": "field_00020"
                    },
                    "children": null,
                    "hasChildren": false
                }
            ],
            "hasChildren": true
        }
    ],
    "hasChildren": true
}




Image AddedRelated use cases

Page properties report
headingsAutomated action, JWT feature, Label

Related examples

Page properties report
firstcolumnUse case
headingsAutomated action, Use case description, Complexity
cqllabel = "use-case-auto" and label = "update-field" and space = "JWTSDC"


Excerpt Include
DECADIS:Contact support
DECADIS:Contact support
nopaneltrue


Page properties
hiddentrue


JWT feature

Image Added

Automated action
Parser functions

fieldValue()

sum()

subtasks()

Label




Page properties
hiddentrue



Status
Tech review

Status
colourGreen
titledone

Style guide

Status
colourGreen
titledone

Status
titleto do
Status
colourGreen
titledone
Status
colourYellow
titleneeds review
Status
colourRed
titleflagged