|
Siebel Developer's Reference > Operators and Expressions > Expressions >
Using Expressions In the Calculated Field and Field Validation Properties
The Calculated Value property of a field specifies an expression that Siebel CRM uses to calculate the value of a field. The Validation property restricts the values for a single value field. Siebel CRM evaluates the Validation property only if the user modifies the value in this field in the client. It evaluates the Validation property of the business component fields that the current applet references. If these fields are part of other business components, then Siebel CRM also validates these fields. Note the following:
- The entire expression for the calculated value or validation must reside on one line.
- The Calculated Value property and the Validation property can contain no more than 255 characters.
- To reference a field value, you must use
[Field Name].
- You cannot use the Validation property to make the field required if this property references another field value.
- Siebel CRM cannot validate a multivalue field.
Elements You Can Use in Calculated Fields and Query By Example
Table 209 describes the elements that you can use in the Calculated Value property, Validation property, or in a query by example expression.
Table 209. Elements You Can Use in Calculated Fields and Query By Example
|
|
Calculated value or validation statement |
You can use the following statements:
|
Condition |
You can use the following conditions:
|
Comparison |
You can use the following comparisons:
- = (equal to)
- < (less than)
- > (greater than)
- <= (less than or equal to)
- >= (greater than or equal to)
- ~ (tilde. Case-insensitive string comparison in the Calculated Value property.)
- NOT (not equal to)
- [~] LIKE (Case-insensitive string comparison)
|
Expression |
You can use the following expressions:
- constant
- identifier
- function
|
Constant |
You can use the following constants for the Calculated Value property, the Validation property, and query by example:
- number.
- string. You must enclose this string in double quotes.
- date. You must enclose this date in double quotes and you must use a forward slash (/) for the separator:
"MM/DD/YYYY"
- time. You must enclose this time in double quotes and you must use a colon (:) for the separator:
"HH:MM:SS"
- date and time. You must enclose this date and time in double quotes and you must use a space to separate the date from the time:
"MM/DD/YYYY HH:MM:SS"
To reference a date and time format in a control or list column, you must use the format that the Control Panel specifies. You can use the following constants only for the Calculated Value property, the Validation property, but not query by example:
- integer.
- currency.
- Boolean.
- phone number. You must enclose this phone number in double quotes.
|
Identifier |
[field name] |
Searching with Query By Example
You can configure Siebel CRM to use query by example (QBE) through list columns or controls as a predefined query or in the Search Specification property. The format is slightly different in the client but in all situations the format is simple BNF (Backus-Naur Format).
|
