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`)
Query Wildcards (e.g.: `:@pageid`)		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
Basic REST Datasources
OAuth REST Datasources
Application Link Datasources		⚠ This feature is not possible to implement in the Cloud.
SQL Datasources
Custom JDBC Drivers		⚠ This feature is technically impossible in the Cloud. You can only use JDBC Drivers / Datasource Types that we have implemented. However, we are always adding new JDBC drivers / Datasource Types to our list. If you think there’s one missing, please let us know. Currently available JDBC Datasources: Postgres MySQL MariaDB MSSQL (Microsoft SQL Server) Oracle IBM DB2 SAP HANA
Custom Templates
Custom Template `$PocketQuery` Velocity API		+ More helpers than on DC and `$PQ` shorthand syntax. Unfortunately, Confluence context objects like `$req` that exist on Server are impossible to implement in the Cloud.
Custom Template `PocketQuery` JavaScript API		⚠ Partially available. `PocketQuery.load` is not available yet.
Custom Template Charting API
Custom Template Velocity Version	Version 1.x	Version 2.x (more features)
Custom Template Errors in Debug Mode
Custom Converters
Custom Converter Syntax	EcmaScript Version 5	EcmaScript Version 2020 (more features)
Custom Converter Errors in Debug Mode
Custom Converter API
Render any Query result with the Default Template	On DC, Query results must always be in a table layout. This often requires the use of a Converter.
Add Query results to the Confluence search index		Not possible. Confluence Cloud is missing APIs needed to implement a feature like this.
PocketQuery Macro Debug Mode		(+ more information than on Server)
PocketQuery Macro “Change Params Template”
PocketQuery Macro “Allow URL parameters”		Technically not possible on the Cloud platform.
Restricting Queries to spaces
Require dedicated spaces for queries
Custom PocketQuery Administrators & Editors Group
Import / Export of Entities	(Support of Server->Server)	(Support of DC->Cloud & Cloud->Cloud)
Copying Entities
PDF / Word Export
Nested Queries
Accept XML results from REST Datasources
Testing queries from within PocketQuery Administration		Queries currently need to be tested by adding the PocketQuery macro to a Confluence page