ZenQL search – data types
Log in to add to favouritesZenQL supports the following data types. These data types are represented in the JSON response of our resources and are documented here for reference.
DateTime
Dates and time are stored as UTC for all our resources. However, you can provide ZenQL with a variety of date and time formats to make searches easier.
| Format | Example |
| yyyy-MM-ddTHH:mm:ss.sTZD (ISO standard) | |
| yyyy-MM-dd | 1997-07-09 |
| yyyy-MM-dd HH:mm | 1997-07-09 19:20 |
| yyyy-MM-dd HH:mm:ss | 1997-07-09 19:20:30 |
| yyyy/MM/dd | 1997/07/09 |
| yyyy/MM/dd HH:mm | 1997/07/09 19:20 |
| yyyy/MM/dd HH:mm:ss | 1997/07/09 19:20:30 |
| Time Period | -5d, 4w 2d, see Relative time period |
All of the above formats are also valid in single month and/or single day formats, for example, 1997-7-9 (yyyy-M-d) or 1997/7/9 (yyyy/M/d).
Dates and time periods do not need to be wrapped in quotes, for example:
sys.version.modified > 2020-03-01
sys.version.modified > 2020-03-01 12:00:00
sys.version.published > 5d
String
String searches are not case sensitive, for example:
sys.contentTypeId = plant is the same as sys.contentTypeId = Plant
Multi-word phrases should be wrapped in double quotes.
description ~ "your home"
If a field name or field value consists of a ZenQL keyword, then the field name or value must be wrapped in double quotes.
Numeric
Integers or decimals do not need to be wrapped in double quotes.
height > 10.0 or height < 10
Boolean
Boolean values are also expressed without double quotes.
displayOnHomepage = true or displayOnHomepage = false
UUIDs
ZenQL intrinsically understands a UUID of a resource and does not need to be wrapped in quotes.
sys.id = 3695fac7-bbe4-4637-894a-8857bc662638