Salesforce

Supported Query Operators (Magic xpi 4.6)

« Go Back

Information

 
Created ByKnowledge Migration User
Approval Process StatusPublished
Objective
Description

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.

Condition

Operator

Value

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

Reference
Attachment 
Attachment