Skip to main content
Browse Documentation

ZenQL search – cheat sheet

Created by r.saunders, last updated 15 Jun 2022

Entries

Edited by me today

sys.version.modified between(startOfDay(), endOfDay()) and sys.version.modifiedBy = currentUser()

Edited by me this week

sys.version.modified between(startOfWeek(), endOfWeek()) and sys.version.modifiedBy = currentUser()

Edited by me this month

sys.version.modified between(startOfMonth(), endOfMonth()) and sys.version.modifiedBy = currentUser()

Edited by me this year

sys.version.modified between(startOfYear(),endOfYear()) and sys.version.modifiedBy = currentUser()

Awaiting approval

sys.workflow.state = "awaitingApproval"

Created this month

sys.version.created between(startOfMonth(), endOfMonth())

Published this month

sys.version.published between(startOfMonth(), endOfMonth())

Archived this month

The Include archive checkbox must be checked to use this query.

sys.version.archived between(startOfMonth(), endOfMonth())

In draft

sys.workflow.state = "draft"

Entries not published

sys.isPublished = false

Published entries

sys.isPublished = true

Published this week

sys.version.published between(startOfWeek(), endOfWeek())

Published last week

sys.version.published between(startOfWeek(-1), endOfWeek(-1))

Due to be unpublished

This search is only avaliable in the Management API and UI.

sys.schedules.unpublish exists and sys.schedules.publish.dateTime > now() 

Due to be unpublished in the next month

This search is only avaliable in the Management API and UI.

sys.schedules.unpublish exists and sys.schedules.publish.dateTime between( startOfMonth(1), endOfMonth(1))

Entries due to be published

This search is only avaliable in the Management API and UI.

sys.schedules.publish exists and sys.schedules.publish.dateTime > now()

Translations out of date

This search is only avaliable in the Management API.

sys.translationState = translationOutOfDate and sys.versionStatus = latest

Translations out of date for specific language e.g. Welsh

This search is only avaliable in the Management API.

sys.translationState = translationOutOfDate and sys.versionStatus = latest and sys.language = cy

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.