Skip to main content

Cookie control banner

Necessary Cookies
These cookies are necessary for this website to function correctly. They are set when you perform certain actions on the site, such as creating an account, logging in, changing your privacy preferences or submitting a form. You can block these cookies in your browser, but this will stop parts of the site from working properly.
Functional Cookies
These cookies allow the website to provide extra functionality and more personalised experiences. They may be set by us or by third party providers whose services we have added to our pages. If you choose not to allow these cookies, these services may not work correctly.
Analytical Cookies
These cookies record anonymous data on how visitors use our website to help us monitor how well our website works. This data includes how many people have looked at specific pages, how long visitors stay on the site, and what devices they use. We use this data to identify changes that we could make to improve your experience and make our website more efficient.
Marketing Cookies
We set some cookies so you are shown more relevant marketing content. These include cookies from third-party advertising networks to show you different adverts on their services if you have previously visited our site. If you choose not to allow these cookies, you may experience less relevant advertising on other sites.
Browse Documentation

ZenQL search – operators

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

An operator in ZenQL is one or more symbols or words which compares the value of a field on its left with one or more values or functions to its right. Only true results are retrieved by the query.

Predicate operators

Equal to: =

All entries of the content type plant.

sys.contentTypeId = plant

All entries where the description field is empty.

description = NULL

Not equal to: !=

The exclamation mark before the equals sign can be used to negate the result of an equal to operator. This example will show all entries that are not from the plant content type.

sys.contentTypeId != plant

All entries where the description field is not empty.

description != NULL

Contains: ~

Search for all entries with a field called description containing the phrase fern. This operator only searches the first 8,000 characters of the field. To search efficiently for complete words across the whole field, use the FREETEXT operator.

description ~ fern

Does not contain: !~

Search for all entries with a field called description that does not contain the phrase fern. This operator only searches the first 8,000 characters of the field. To search efficiently for complete words across the whole field use the FREETEXT operator.

description !~ fern

Greater than: >

All entries where the field height is greater than 100.

height > 100

Less than: <

All entries where the field height is less than 100.

height < 100

Greater than or equal to: >=

All entries with a height of 100 or greater.

height >= 100

Less than or equal to: <=

All entries with a height of 100 or less.

height <= 100

IN

All entries that have a plantType value from the list, either palm or cacti or ferns. e.g. Show me all plants that are palms, cacti or ferns.

plantType IN (palm, cacti, ferns)

NOT IN

All entries that do not have a plantType value from the list, either palm or cacti or ferns. For example, Show me all plants that are not palms, cacti or ferns.

plantType NOT IN (palm, cacti, ferns)

EXISTS

All entries that have a latinName field.

latinName EXISTS

NOT EXISTS

All entries that do not have a latinName field.

latinName NOT EXISTS

STARTSWITH

All entries with a title value that begins with the case-insensitive string Chine.

title STARTSWITH Chine

NOT STARTSWITH

All entries with a title value that does not start with the case-insensitive string Chine.

title NOT STARTSWITH Chine

ENDSWITH

All entries with a title value that ends with the case-insensitive string s.

title ENDSWITH s

NOT ENDSWITH

All entries with a title value that does not end with the case-insensitive string s.

title NOT ENDSWITH s

DistanceWithin

DistanceWithin provides a proximity search based on a latitude and logitude. All entries with a plantOrigin lat-lon value within a 100km radius of the stated coordinates.

plantOrigin DistanceWithin(25.1363888,97.3733773, 100km)

NOT DistanceWithin

DistanceWithin provides a proximity search based on a latitude and logitude. All entries with a plantOrigin lat-lon value outside of a 100km radius of the stated coordinates.

plantOrigin NOT DistanceWithin(25.1363888,97.3733773, 100km)

FREETEXT

All entries with a description field containing both words your and home.

description FREETEXT “your home”

* FREETEXT: Any field containing the string

All entries with any field containing the string interior.

* FREETEXT interior

* FREETEXT: Any field containing multiple specified words

All entries with any field containing both words your and home.

* FREETEXT “your home”

FREETEXT with title field boosted

All entries with the word Boston, but bring entries with Boston in their title higher in the search results by boosting the title field.

title^80 FREETEXT “Boston”

NOT FREETEXT

All entries where the description field does not contain the words your home.

description NOT FREETEXT “your home”

Operator API support

Operator Entries Users & Groups
Equal to
Not Equal to
Contains
Does not contain
Greater than
Less Than
Greater than or equal to
Less than or equal to
In
Not in
Exists -
Not exists -
Starts with
Not starts with
Distance proximity -
Outside distance proximity -
Freetext
Not freetext