Type
and
Description
Performs a logical AND between all conditions 
Properties
Name Type Description
and condition[] List of conditions to AND
Samples
State = "Active" AND StartDate>"Jan 2nd 2014" 
{
    "and": [
        {
            "leftExpression": {"fieldName": "State"},
            "operator": "Equal",
            "rightExpression": {"value": "Active"}
        },
        {
            "leftExpression": {"fieldName": "StartDate"},
            "operator": "GreaterThan",
            "rightExpression": {"value": "2014-01-02"}
        }
    ]
}
Type
or
Description
Performs a logical OR between all conditions 
Properties
Name Type Description
or condition[] List of conditions to OR
Samples
State = "Active" OR StartDate>"Jan 2nd 2014" 
{
    "or": [
        {
            "leftExpression": {"fieldName": "State"},
            "operator": "Equal",
            "rightExpression": {"value": "Active"}
        },
        {
            "leftExpression": {"fieldName": "StartDate"},
            "operator": "GreaterThan",
            "rightExpression": {"value": "2014-01-02"}
        }
    ]
}
Type
not
Description
Perform a logcial NOT on a condition 
Properties
Name Type Description
not condition The sub condition
Type
compare
Description
Compare two expressions 
Properties
Name Type Description
leftExpression expression First expression to compare
operator operator The comparison operator
rightExpression expression Second expression to compare
Samples
State IN ("Active","Draft") 
{
    "leftExpression": {"fieldName": "State"},
    "operator": "In",
    "rightExpression": {
        "values": [
            "Active",
            "Draft"
        ]
    }
}
Type
cZQLCondition
Description
Provide a where condition using CZQL 
Properties
Name Type Description
text string The condition text (e.g. PercentCompleted>50 AND DueDate>:dateParam) You can use bind parameters in the condition text and fill the parameter values using Parameters property
parameters parameters Values for bind parameters
Samples
State IN ("Active","Draft") 
{
    "text": "State IN (\"Active\",\"Draft\") and StartDate>:startDateParam",
    "parameters": {
        "startDateParam": "2014-01-01"
    }
}
Note that the above sample can be sent without escaping quotes by using single quotes and by sending parameters inline: 
{
    "text": "State IN ('Active','Draft') and StartDate>'2014-01-01'"
}