Japanese characters) - as long the query itself is URL Encoded properly.įor query parameters that represent a relationship to the resource, only first level attributes can be supplied in the expression. Quoted Strings can contain Unicode characters (e.g.There is no need to escape a single quote in a double quoted string and vice versa.In double quoted strings, a double quote can be escaped using a backslash (similar to Strings in Java code).In single quoted strings, a single quote can be escaped using another single quote in front of it (similar to SQL).Both single quoted strings and double quoted string can be used as values.Only numbers in US-ASCII format are supported.

Numbers with decimal places and exponents are not supported.

Negative and positive integer and long numbers are supported.

Quoted null strings like 'null', 'NULL', 'NuLl' are not allowed.

The null value keyword is never allowed.

you cannot mix Date with DateTime in the same expression). in, matchAll, etc.), all the values in the parenthesized list has to be in the same format (i.e.

When used with multi-valued operators (e.g.

When used with Range operators, types of both the lower limit and upper limit values have to be in the same format (i.e.

Any other format of date will be treated as string and will fail date format validation leading to query error.DateTimeZone is date time - with time zone info - it has to be in the format 'YYYY-MM-dd'T'HH:mm-ssZ' where HH is 24 hour format and z is time zone.DateTime is date with time - without any time zone info - it has to be in the format 'YYYY-MM-dd'T'HH:mm-ss' where HH is 24 hour format.Date is date without the time portion - it has to be in the format 'yyyy-MM-dd'.All types of Date related values have to be [single/double) quoted strings.Quoted strings like 'true' or 'false' are not allowed.Boolean values have to be always the true or false keywords.This operator is only supported for Category objects with query parameters recordId and referenceKey. Interpreted as 'equal to with no children'. ReputationPoints lt 200 or dateAdded lt ''Ĭategories.referenceKey withNoChildren 'EUROPE' This operator is only supported for query parameters that represent a to-many relationship from the resource to Category objects and can only be used with attributes recordId and referenceKey. This operator is only supported with query parameters that represent a to-many relationship to the resource with attributes recordId and referenceKey.Ĭategories.referenceKey matchAllWithNoChildren ('ASIA', 'EUROPE') The before operator is a synonym.Ĭategories.referenceKey matchAll ('ASIA', 'EUROPE') This operator can be used to achieve starts-with, ends-with and contains string expressions. The wild card character is '*', as '%' is the wild card character in SQL statements. The onOrBefore operator is a synonym.įirstName likeAny ('Pete*', '*Pa*', 'Jo*n') This operator is the multi-valued version of the withNoChildren operator. This operator supports multiple values grouped by parentheses.Ĭategories.referenceKey inWithNoChildren ('ASIA', 'EUROPE') Ĭategories.referenceKey in ('ASIA', 'EUROPE') For this operator, both the lower and upper limits are exclusive. Interpreted as 'greater than and less than'. For this operator, the lower limit is inclusive, while the upper limit is exclusive. Interpreted as 'greater than or equal to and less than'. For this operator, the lower limit is exclusive, while the upper limit is inclusive. Interpreted as 'greater than and less than or equal to'. For this operator, the limits are inclusive. Interpreted as 'greater than or equal to and less than or equal to'. Interpreted as 'greater than or equal to'. īoolean, String, Integer, Long, Date, DateTime, DateTimeZone See more info in the Combined Expressions section. ReputationPoints lt 200 and dateAdded lt ''Īn Expression or logical combination of Expressions Integer, Long, Date, DateTime, DateTimeZone Example Expression (without URL encoding)

Like all the rest synonym