Syntax
[ NOT ] conditionalExpression [ logicalOperator conditionalExpression [...n ] ]
Parameters
NOT
Relational NOT, inverts the following conditional expression
ConditionalExpression
A conditional expression used to select a subset of the database records associated with the persistent class of which the referencing profile is a member.
This conditional expression is subject to the restrictions mentioned below.
logicalOperator conditionalExpression
A logical operator to apply to a composite profile condition, in conjunction with the specified conditional expression. This conditional expression is subject to the restrictions mentioned below.
Description
Profile conditions specify the criteria used to select a subset of the database records associated with the persistent class of which the referencing profile is a member.
Restrictions
Profile conditions are expressed as conditional expressions that can consist of:
Persistent attributes of the class of which the referencing profile is a member
Constant values
Arithmetic expressions involving numeric constants and/or persistent attributes of the class of which the referencing profile is a member
Profile Key Values
While reading database records, mismatching data types cannot be used as values for profile keys. Use of string in place of numeric (including signed numeric as well as date) and vice versa is disallowed.
The following rules apply for mismatching types:
Only Strings are allowed as values for keys defined as strings.
Dates and numeric can be used interchangeably for keys defined as numeric or date.
Only boolean are allowed as values for keys defined as boolean.
Only NationalString values are allowed for keys defined as NationalString (except for GLB.SPACES, GLB.HIGH, and GLB.LOW that are allowed as values for NationalString keys.
Example
This condition specifies that the profile should retrieve records where the value of the Price attribute exceeds 10000 or if both the value of the Price attribute does not exceed 10000 and the CustType attribute is set to "A":
Price > 10000 || (Price <= 10000 && CustType = "A")