Cloud and Data Center Differences

There are some feature discrepancies between PocketQuery for Confluence Cloud & Data Center. While the basic functionality remains the same across both versions, there are some differences when it comes to more advanced functionality. We are working on creating feature parity between the two. Please let us know if one of the features is urgent for you so you can help us prioritize them better.

Feature

Data Center

Cloud

Query Parameters (e.g.: :parameter)

check mark

check mark

Query Wildcards (e.g.: :@pageid)

check mark

check mark Wildcards starting with @user are not available in Cloud due to security and privacy restrictions. The @spacecategory wildcard is not available in Cloud (yet)

Custom REST Datasources

check mark

check mark

Basic REST Datasources

check mark

check mark

OAuth REST Datasources

check mark

check mark

Application Link Datasources

check mark

⚠ This feature is not possible to implement in the Cloud.

SQL Datasources

check mark

check mark

Custom JDBC Drivers

check mark

⚠ Custom drivers are not possible in the Cloud. Please go to Datasources for available drivers. If you think there’s one missing, please let us know.

Custom Templates

check mark

check mark

Custom Template $PocketQuery Velocity API

check mark

check mark + More helpers than on DC and $PQ shorthand syntax. Confluence context objects like $req that exist on Server are not available in the Cloud.

Custom Template PocketQuery JavaScript API

check mark

check mark

Custom Template Charting API

check mark

check mark

Custom Template Velocity Version

Version 1.x

Version 2.x (more features)

Custom Template Errors in Debug Mode

cross mark

check mark

Custom Converters

check mark

check mark

Custom Converter Syntax

EcmaScript Version 5

EcmaScript Version 2020 (more features)

Custom Converter Errors in Debug Mode

cross mark

check mark

Custom Converter API

check mark

check mark

Render any Query result with the Default Template

cross mark On DC, Query results must always be in a table layout. This often requires the use of a Converter.

check mark

Add Query results to the Confluence search index

check mark

cross mark Not possible. Confluence Cloud is missing APIs needed to implement a feature like this.

PocketQuery Macro Debug Mode

check mark

check mark (+ more information than on Server)

PocketQuery Macro “Change Params Template”

check mark

check mark

PocketQuery Macro “Allow URL parameters”

check mark

cross mark Technically not possible on the Cloud platform.

Restricting Queries to spaces

check mark

check mark

Require dedicated spaces for queries

check mark

check mark

Custom PocketQuery Administrators & Editors Group

check mark

check mark

Import / Export of Entities

check mark (Support of Server->Server)

check mark (Support of DC->Cloud & Cloud->Cloud)

Copying Entities

check mark

check mark

PDF / Word Export

check mark

check mark

Nested Queries

check mark

check mark

Accept XML results from REST Datasources

check mark

check mark

Testing queries from within PocketQuery Administration

check mark

check mark