Bookshelf Home | Contents | Index | PDF |
Siebel Developer's Reference > Operators, Expressions, and Conditions > Calculated Field Values and Field ValidationThe Calculated Value property specifies an expression for calculating the value of a field. A field's Validation property allows you to restrict the values for a single value field (validation is not supported for MVFs). The validation property is evaluated when the field is accessed and modified in the GUI only. The validation properties from the current applet's business component fields are evaluated. If these fields are part of other business components as well, those validation properties are not evaluated. NOTE: The Calculated Value and field Validation properties are limited to 255 characters. The syntax for the Calculated Value or Validation property is the same as the QBE syntax, with different but overlapping functions. The comparison, logical AND, and logical OR operators are valid for these properties. The syntax follows. The Calculated Value or Validation expression must be all on one line. Calculated Value or Validation StatementCondition: comparison Comparison: [~] [= | < | > | <= | >= | [NOT] [~] LIKE] expression Expression: constant Constant: number identifierFor date and time formats in controls or list columns, use the format specified in the Control Panel. In Search Specification or predefined query form, use the business component format. To reference a field value, you must use [Field Name]. Also, string constants must be enclosed in double quotation marks ("string"). You can use the tilde (~) modifier to make case-insensitive string comparisons in Calculated Value expressions. NOTE: A field's Validation property cannot be used to make the field required based on another field value. When a Calculated Value statement references more than one field value, and the fields have different data types, the order of the data types can have an effect on the calculation. For example, the Quote Item business component has the calculated field Line Total, whose calculated value is If Item Price is |
Siebel Developer's Reference |