Siebel Advisor Administration Guide > Working with Advisor Configuration Tables >

Range Functions for Advisor Configuration Tables


Use range functions in input columns to simplify data entry and create smaller models for faster application load time. For example, instead of creating three separate rows in a Configuration table to create a rule that displays an exception message when a user selects the colors red, blue, and green, you can create one row and enter the range function (=Red,Blue,Green).

NOTE:  For rules involving more than one code value, the syntax (=bm*) cannot be used; doing so causes an error when generating HTML files in Advisor. Instead, use the syntax (=bm1,bm2,bm3) or (=*).

Table 2 shows examples of range functions:

Table 2. Examples of Range Functions
Range Function
Description

(=Red,Blue)

Anything equal to Red or Blue

(=1-3)

Anything that numerically matches, numbers only

(=*)

All

(!=Red,Blue)

Anything not equal to Red and not equal to Blue

Siebel Advisor Administration Guide Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Legal Notices.