Relative operators

Relative operators are allowed in queries. The following table shows the relative operators available for constructing a custom query clause.
Operator
Description
=
The value of the attribute must be equal to the value of the constant.
!=
The value of the attribute must not be equal to the value of the constant; however, the attribute must exist.
<
The value of the attribute must be less than the value of the constant.
<=
The value of the attribute must be less than or equal to the value of the constant.
>
The value of the attribute must be greater than the value of the constant.
>=
The value of the attribute must be greater than or equal to the value of the constant.
match
The value of the attribute must match a value of the constant, where the constant can include the wild card characters "*" and "?". The wild card "*" matches any number of missing characters and the wild card "?" matches a single missing character. The match operator is case-sensitive.

You can use the wild card match only on the first 63 characters of an attribute.

!match
The value of the attribute cannot match any of the possible values of the constant.

Feedback