Multi-property WHERE
Use this extension to the WHERE cause to allow for logical expressions of multiple property restrictions.
Syntax
WHERE expression logical_operator expression
expression
An expression is in the following format.
property_name operator property_value
Multiple expressions can be specified. Use parentheses to indicate a desired evaluation precedence.
logical_operator
Specify how the expressions are to be associated. A series of expressions must be separated by one of the following logical operators.
AND: Both conditions must be true
OR: Either condition must be true.
operator
Use the following operators in an expression:
=
<
<=
>
>=
<>
Example
RENAME DEFINITION "User 1" TO "XXX"
RENAME DEFINITION "User 2" TO "YYY"
LIST "Influence Type"
{
VALUE "Internal Influence"
VALUE "External Influence"
VALUE "Another"
}
DEFINITION "XXX"
{
PROPERTY "Influence1" {EDIT TEXT LISTONLY LIST "Influence Type" DEFAULT "External Influence" INITIAL USER REQUIRED CAUSESAPPLY}
PROPERTY "Influence2" {EDIT TEXT LISTONLYCOMBO LIST "Influence Type" DEFAULT "External Influence" INITIAL USER REQUIRED CAUSESAPPLY}
PROPERTY "Influence3" {EDIT TEXT LISTONLYCOMBO LIST "Influence Type" DEFAULT "External Influence" INITIAL USER REQUIRED CAUSESAPPLY}
PROPERTY "Influence4" {EDIT TEXT LISTONLYCOMBO LIST "Influence Type" DEFAULT "External Influence" INITIAL USER REQUIRED CAUSESAPPLY}
PROPERTY "Influence5" {EDIT TEXT LISTONLYCOMBO LIST "Influence Type" DEFAULT "External Influence" INITIAL USER REQUIRED CAUSESAPPLY}
}
DEFINITION "YYY"
{
PROPERTY "XXXDef" {EDIT ONEOF "XXX" WHERE "Influence1" = "Internal Influence" AND ("Influence2" <> "External Influence" OR "Influence3" = "Another") AND ("Influence4" = "Internal Influence" OR "Influence5" = "External Influence") FROM_CHOICES_ONLY}
}