Skip to main content
New support request

ZenQL search – cheat sheet

Log in to add to favourites

Entries

Edited by me today

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

Edited by me this week

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

Edited by me this month

JAVASCRIPT
1
2

Edited by me this year

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

Awaiting approval

JAVASCRIPT
1
2
sys.workflow.state = "awaitingApproval"

Created this month

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

Published this month

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

Archived this month

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

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

In draft

JAVASCRIPT
1
2
sys.workflow.state = "draft"

Entries not published

JAVASCRIPT
1
2
sys.isPublished = false

Published entries

JAVASCRIPT
1
2
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.

JAVASCRIPT
1
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

Still need help?

New support request