Canned Search for Confluence Cloud

Differences in CQL between Confluence Cloud and Data Center

Introduction

For those who are doing migration from Confluence Data Center to Confluence Cloud, there are some differences between the two. Some CQL statements might not work if you just copy and paste the statements across.

We have summarized the differences below.
Hope it helps.


Feature Parity

CQL Fields

Field

Cloud

Data Center

Remarks

Ancestor

check mark

check mark

In Confluence Cloud, the ancestor function in CQL does not support non-page content (e.g., whiteboards, databases, embeds, folders). See CONFCLOUD-80607

Container

cross mark

check mark


Content

check mark

check mark


Created

check mark

check mark


Creator

check mark

check mark

The username needs to be replaced with the account ID

Contributor

check mark

check mark

The username needs to be replaced with the account ID

favourite, favourite

check mark

check mark


ID

check mark

check mark


Label

check mark

check mark


LastModified

check mark

check mark


Macro

check mark

check mark


Mention

check mark

check mark

The username needs to be replaced with the account ID

Parent

check mark

check mark


PageStatus

check mark

cross mark


Space

check mark

check mark


space.category

cross mark

check mark


space.key

cross mark

check mark


space.title

cross mark

check mark


space.type

cross mark

check mark


Text

check mark

check mark


Title

check mark

check mark


Type

check mark

check mark

Cloud supports additional content types

  • whiteboard

  • database

  • embed

  • folder

Watcher

check mark

check mark

The username needs to be replaced with the account ID

User

check mark

cross mark



CQL Functions

Field

Cloud

Data Center

Remarks

currentUser()

check mark

check mark


endOfDay()

check mark

check mark


endOfMonth()

check mark

check mark


endOfWeek()

check mark

check mark


endOfYear()

check mark

check mark


startOfDay()

check mark

check mark


startOfMonth()

check mark

check mark


startOfWeek()

check mark

check mark


startOfYear()

check mark

check mark


favouriteSpaces()

check mark

check mark


recentlyViewedContent()

check mark

check mark

For Cloud, this function can only return a maximum of 200 results.

recentlyViewedSpaces()

check mark

check mark

For Cloud, this function can only return a maximum of 200 results.


References