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




Features used to implement the example



Example:

 Setting Calculated Text Field depending on custom fields

Show timeliness of an issue based on two date pickers

In this example, the value timeliness of an issue is displayed using a calculated text field get's set by evaluating 2 other that is set based on two additional date picker custom fields.For this example the following custom fields are needed:

  • Date Picker custom field "Date closed"
  • Date Picker custom field "Expected Due Date"


The Calculated Text Field The display value should be set on with the following conditions:

  • if (Date closed = null && Current Day <= Expected Due Date) { "" }
  • if (Date closed <= Expected Due Date) { "Yes" }
  • if (Date closed > Expected Due Date || (Date closed = null && Current Day > Expected Due Date)) { "No" }


The configuration will look like this:

Text to be parsed is: {10423} != null ? ({10423} <= {10424} ? "Yes" : "No") : (datePart({000057}, LOCAL) > {10424} ? "No" : null)


Note that:

  • {10423} is the field code for custom date picker "Date closed" (your this field code might be differentdiffer on your instance)
  • {10424} is the field code for custom date picker "Expected Due Date" (your this field code might be differentdiffer on your instance)


Other examples of that function

Incoming Links
pageCalculated Text field
labelsexample



Related Usage Examples

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