Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from this space and version 2.7.0


Section


Column
width600px


Panel
borderColor#333f48
bgColor#FFFFFF
titleColor#eeeeee
borderWidth1
titleBGColor#333f48
borderStylesolid
titleOn this page

Table of Contents
maxLevel1



Column




Example:

 Setting

Setting the priority depending on the

product

multiplication of custom fields

In this example, the priority of an issue should be set depending on the product result of multiplying 2 two custom fields.

For this, 3 three custom fields are needed:

  • "Impact" (Number Default number custom field)
  • "Probability" (Number Default number custom field)
  • "Rating" (Calculated Number Field) for storing [(Impact * Probability])


Depending on the outcome of the productmultiplication, the priority should be set as the following:

RatingPriority
13-16Highest
9-12High
4-8Medium
1-3Low


The configuration of the Calculated Number Field "Rating" will look like this:


Text to be parsed is: {10417} * {10418}


Note that:

  • {10417} is the field code for custom number field "Impact" (it may be different to your codethis field code might differ on your instance)
  • {10418} is the field code for custom number field "Probability" (it may be different to your code)this field code might differ on your instance)


For this we need the The configuration of post function Set a field as a function of other fields will look like this. The configuration looks like the following:


Text to be parsed is: 

[{10419} >= 1 AND {10419} <= 3]Low
[{10419} >= 4 AND {10419} <= 8]Medium
[{10419} >= 9 AND {10419} <= 12]High
[{10419} >= 13 AND {10419} <= 16]Highest


Note that:

  • {10419} is field code for calculated number field "Rating" (it may be different to your code)this field code might differ on your instance)


Once configuredAfter the configuration, the transition will look like this:




Other examples of that function

Incoming Links
pageSet a field as a function of other fields
labelsexample



Related Usage Examples

Content by Label
showSpacefalse
cqllabel = "example" and label in ("post-function","calculated-field")