Supported Query Operators (Magic xpi 4.6)
Queries are used to retrieve information from entities. The following table shows the comparison operators that are currently supported by the Dynamics CRM connector's Query operation.
|
|
|
|
|
Equals x
|
=
|
x
|
|
Does not equal x
|
!=
|
x
|
|
Is greater than x
|
>
|
x
|
|
Is greater than or equal to x
|
>=
|
x
|
|
Is less than x
|
<
|
x
|
|
Is less than or equal to x
|
<=
|
x
|
|
Begins with x
|
LIKE
|
x%
|
|
Does not begin with x
|
NOTLIKE
|
x%
|
|
Ends with x
|
LIKE
|
%x
|
|
Does not end with x
|
NOTLIKE
|
%x
|
|
Contains x
|
LIKE
|
%x%
|
|
Does not contain x
|
NOTLIKE
|
%x%
|
|
On x
|
DATEON <Date>
|
x
|
|
Is null
|
ISNULL
|
N/A
|
|
Is not null
|
ISNOTNULL
|
N/A
|
