Supported Query Operators - Sharepoint (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 Sharepoint connector's Query operation.
The operators can only be used with string fields.
|
|
|
|
*
|
Equal to
|
|
contains
|
Contains
|
|
beginswith
|
Begins with
|
|
!=
|
Not equal to
|
|
<>
|
Not equal to
|
|
<=
|
Less than or equal to
|
|
>=
|
Greater than or equal to
|
|
=
|
Equal to
|
|
<
|
Less than
|
|
>
|
Greater than
|
|
IsNull (Since version: 4.5)
|
Null
|
|
IsNotNull (Since version: 4.5)
|
Not Null
|
