/
Differences in CQL between Confluence Cloud and Data Center

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

Field

Cloud

Data Center

Remarks

Ancestor

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

Container

 

Content

 

Created

 

Creator

The username needs to be replaced with the account ID

Contributor

The username needs to be replaced with the account ID

favourite, favourite

 

ID

 

Label

 

LastModified

 

Macro

 

Mention

The username needs to be replaced with the account ID

Parent

 

PageStatus

 

Space

 

space.category

 

space.key

 

space.title

 

space.type

 

Text

 

Title

 

Type

Cloud supports additional content types

  • whiteboard

  • database

  • embed

  • folder

Watcher

The username needs to be replaced with the account ID

User

 

 

CQL Functions

Field

Cloud

Data Center

Remarks

Field

Cloud

Data Center

Remarks

currentUser()

 

endOfDay()

 

endOfMonth()

 

endOfWeek()

 

endOfYear()

 

startOfDay()

 

startOfMonth()

 

startOfWeek()

 

startOfYear()

 

favouriteSpaces()

 

recentlyViewedContent()

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

recentlyViewedSpaces()

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

 

References