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 – keywords

Created by r.saunders, last updated 14 Feb 2022

A keyword in ZenQL is a word or phrase that does any of the following:

  • joins two or more clauses together to form a complex ZenQL query
  • alters the logic of one or more clauses
  • alters the logic of of an operator

You can use the following keywords in your ZenQL queries. 

AND

Used to combine multiple clauses, allowing you to refine a search.

  • Find all plants that are published.
    sys.contentTypeId = plant and sys.isPublished = true

OR

Used to check if any of the conditions are met in a clause.

  • Find all entries that are plants or pots.
    sys.contentTypeId = plant or sys.contentTypeId = pot

NOT

Used to ensure that the search condition is not true.

  • Find all entries that are not plants.
    not sys.contentTypeId = plant alternatively sys.contentTypeId != plant
  • Find all entries where the entry title does not start with chinese.
    entryTitle not startswith chinese

BETWEEN

Used to search within a range. Can be used with numbers and dates.

  • Find all pots that have a height between 6 and 12 centimetres.
    sys.contentTypeId = pot and height between(6,12) 
  • Show all pots created between last month and this month.
    sys.contentTypeId = pot and sys.version.created between(startOfMonth(-1),endOfMonth())

SCOPE: ()

Scopes using parenthesis allow you to compare and combine multiple complex clauses.

  • Find all plant or pots that were created on or after the 6th December 2021.
    sys.contentTypeId = plant or (sys.contentTypeId = pot and sys.version.created >= 2020-12-06