Creating Javascript Conditional Statements for Advisor Applications

Create an OL_CONDITIONS Configuration table to evaluate the current input UI control selections in the application against javascript conditional statements. These statements are evaluated and, based on the results, a message can be presented to the user.

For information on how the OL_CONDITIONS Configuration table is evaluated, see "The Configuration Matching Process".

To create an OL_CONDITIONS Configuration table

1. Create a Configuration table.

   See "Process of Creating Advisor Configuration Tables" for more information.

2. Create an input column named TEST.

3. Create an output column named RULE.

4. In the TEST column, enter a JavaScript conditional statement that returns true or false.

   The conditional statement may refer to column values from Feature tables or Configuration tables using the same syntax used in cell functions.

5. In the RULE column, enter the message that appears if the TEST expression returns true.

   Each row in the OL_CONDITIONS table is evaluated in order of SEQUENCE number, from smallest to greatest, against the current user-selected configuration.

   If all of the TEST expressions in the OL_CONDITIONS table return false, the engine considers the user-selected configuration valid and ends the configuration matching process. If a TEST expression returns true, the exception message defined in the associated RULE column appears in the application.

Example 12-2 JavaScript Conditional Statement

Table 12-4 shows an example of a JavaScript conditional statement in the TEST column and the message in the RULE column that appears if the statement is true.

Table 12-4 JavaScript Conditional Statement Example

TEST	RULE
(APPLES.QTY+ORANGES.QTY < BANANAS.QTY)	Your smoothie needs more bananas.