Skip to main content
Browse Documentation
Data types

ZenQL search – data types

Created by r.saunders, last modified by r.bromley on 13 Feb 2022

ZenQL 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.

Date/time formats support by ZenQL
Format Example

yyyy-MM-ddTHH:mm:ss.sTZD (ISO standard)

1997-07-09T19:20:30.45+01:00

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