CellValue
- Last Updated: March 24, 2022
- 3 minute read
- Corticon
- Version 6.3
- Documentation
SYNTAX
Various, see Examples below
When used in an expression, cellValue performs text replacement where the value is determined by the rule Column that executes. Using cellValue in a Condition or Action expression eliminates the need for multiple, separate Rows to express the same logic.
The Operators row of the table in Vocabulary usage restrictions does not apply. Special exceptions: cellValue may only be used in Condition and Action Rows (sections 3 and 5 in Sections of Rulesheet that correlate with usage restrictions).
This sample Rulesheet uses cellValue to
increment integer1 by the amount in the Action Cell
of the rule Column that fires. An equivalent Rulesheet which does not use cellValue
is also shown for comparison purposes.
Equivalent Rulesheet without using cellValue:
A sample Ruletest provides two examples of boolean1. The following table shows Input and Output panels.
The following Rulesheet uses cellValue to
evaluate whether collection1 includes at least one
member with a string1 value of the entry in the
Conditions Cell of the rule Column.
A sample Ruletest provides three examples of collection1 – each member has a string1 value. Input and Output panels are shown below.
The following Rulesheet uses cellValue to
create a new member of collection1 with string1 value equal to the Action Cell in the rule
Column that fires.
A sample Ruletest provides string1
values for three examples. The following illustration shows Ruletest Input and
Output panels. Notice that each collection1 already
has one element prior to executing the test. This simply ensures the results will be
displayed in hierarchical style.