Multi-property WHERE
A multi‑property WHERE clause allows for logical expressions of multiple property restrictions.
Syntax
WHERE expression logical_operator expression
Parameters
expression
An expression is in the following format:
property_name operator property_value
Multiple expressions can be specified. Use parentheses to indicate the evaluation precedence.
logical_operator
Specify how the expressions are to be associated. Separate a series of expressions 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}
}
See also