Type
constantExpression
Description
An expression which represents a constant value (e.g. 1, 'Joe', true, null etc.) 
Properties
Name Type Description
value object The expression value
Samples
In the example below, the highlighted expressions are constant expressions 
{
    "or": [
        {
            "leftExpression": {"fieldName": "State"},
            "operator": "Equal",
            "rightExpression": {"value": "Active"}
        },
        {
            "leftExpression": {"fieldName": "PercentCompleted"},
            "operator": "GreaterThan",
            "rightExpression": {"value": 85}
        }
    ]
}
Type
predefinedDateRangeExpression
Description
An expression which represents a relative DateTime value (e.g. 'ThisMonth', 'LastQuarter', etc.) 
Properties
Name Type Description
value datePeriod
dateRangeValue datePeriod
Type
constantListExpression
Description
An expression which represents array of constant values. Used in IN conditions 
Properties
Name Type Description
values object[] The value list
Samples
In the example below, the highlighted expressions are constantList expressions 
{
    "leftExpression": {"fieldName": "State"},
    "operator": "In",
    "rightExpression": {"values": ["Active","Draft"]}
}
Type
fieldExpression
Description
An expression which represents an object field 
Properties
Name Type Description
fieldName string The name of the field this expression represents (e.g. "Name","PercentCompleted","Manager" etc.)
Samples
In the example below, the highlighted expressions are constantList expressions 
{
    "leftExpression":  {"fieldName": "State"},
    "operator": "In",
    "rightExpression":{"values": ["Active","Draft"]}
}
Type
queryExpression
Description
An expression which represents a query. Used in IN conditions 
Properties
Name Type Description
query query The actual query
Samples
The following example shows how to use a queryExpression with an IN operator to find tasks whose creator name starts with 'S' 
{
    "leftExpression": {"fieldName": "CreatedBy"},
    "operator": "In",
    "rightExpression": {
        "query": {
            "_type": "entityQuery",
            "typeName": "User",
            "where": {
                "leftExpression": {"fieldName": "Name" },
                "operator": "BeginsWith",
                "rightExpression": {
                    "value": "s"
                }
            }
        }
    }
}