5.5

Table Of Contents
Filter Expressions
For queries that do not examine object metadata, you can filter results using string matching or numeric
comparison operations. A filter comprises one or more subexpressions drawn from the following set of
operators.
Table 93. Query Filter Expressions
Operator Example Operation
== attribute==value
Matches. The example evaluates to true if attribute
has a value that matches value in a case-sensitive
comparison.
NOTE Asterisk (*) characters that appear anywhere
in value are treated as wildcards that match any
character string. When value includes wildcards,
the comparison with attribute becomes case-
insensitive.
!= attribute!=value
Does not match. The example evaluates to true if
attribute has a value that does not match value in a
case-sensitive comparison. Wildcard characters are
not allowed.
; attribute1==value1;attribute2!=value2
Logical AND. The example evaluates to true only if
attribute1 has a value that matches value1 and
attribute2 has a value that does not match value2 in
a case-sensitive comparison.
, attribute1==value1,attribute2==value2
Logical OR. The example evaluates to true if
attribute1 has a value that matches value1 or
attribute2 has a value that matches value2 in a case-
sensitive comparison.
=gt= attribute=gt=value
Greater than. The example evaluates to true if
attribute has a value that is greater than value. Both
attribute and value must be of type int, long, or
dateTime.
=lt= attribute=lt=value
Less than. The example evaluates to true if attribute
has a value that is less than value. Both attribute and
value must be of type int, long, or dateTime.
=ge= attribute=ge=value
Greater than or equal to. The example evaluates to
true if attribute has a value that is greater than or
equal to value. Both attribute and value must be of
type int, long, or dateTime.
=le= attribute=le=value
Less than or equal to. The example evaluates to
true if attribute has a value that is less than or equal
to value. Both attribute and value must be of type
int, long, or dateTime.
Not all attributes can be used in a filter expression. For details, see the reference pages for query result types
in the vCloud API Schema Reference.
Specifying Metadata in a Query or a Filter Expression
Because metadata values are dynamic and metadata names have an optional domain qualifier queries that
filter metadata must specify a qualified name, a value, and the type of the value.
n
The domain must be specified for any MetadataEntry that is in the SYSTEM domain. If no DOMAIN is
specified, the query returns the value for key name in the GENERAL domain, if it exists.
vCloud API Programming Guide
300 VMware, Inc.