Versions Compared

Key

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


Section


Column
width600px


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

Table of Contents
maxLevel1



Column




Futures

Features used to implement the example



Example: Setting the priority depending on the product of custom fields

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

For this, 3 custom fields are needed:

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


Depending on the outcome of the product, 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 field code for custom number field "Impact" (it may be different to your code)
  • {10418} is field code for custom number field "Probability" (it may be different to your code)


The configuration of post function Set a field as a function of other fields will look like this:


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)


After 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")