1. Developer’s Reference
  2. Elements You Can Use in Calculated Fields and Query By Example

Elements You Can Use in Calculated Fields and Query By Example

The following table describes the elements that you can use in the Calculated Value property, Validation property, or in a query by example expression.

Element Description

Calculated value or validation statement

You can use the following statements:

  • condition

  • expression

Condition

You can use the following conditions:

  • comparison

  • AND
  • NOT
  • OR

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).