• Fix issue with temp directory during import/export
• Fix issue with space search in query form

• Fix issue with temp directory during import/export
• Fix issue with space search in query form

Fix JSON deserialization issue

Fix JSON deserialization issue

Make OAuth2 access and refresh token non-required

Make OAuth2 access and refresh token non-required

Fix issue with measuring executions time in debug mode

Fix issue with measuring executions time in debug mode

List of allowed spaces on queries now has autocomplete

List of allowed spaces on queries now has autocomplete

Fix issue with statistics not being displayed correctly

Fix issue with statistics not being displayed correctly

Add more logs for relation cache mechanism

Add more logs for relation cache mechanism

Fix issue with datasource password removal confirmation

Fix issue with datasource password removal confirmation

Fix table sorting with dynamic load

Fix table sorting with dynamic load

Confluence 8 compatibility (no new features)

Confluence 8 compatibility (no new features)

Platform & maintenance release (no new features)

Platform & maintenance release (no new features)

• Datasource passwords must be re-entered when datasources are edited
• Do not open preview editor when basic data for entity is missing

• Datasource passwords must be re-entered when datasources are edited
• Do not open preview editor when basic data for entity is missing

• Parameters in the query template are now ordered by their appearance in the query
• Security updates

• Parameters in the query template are now ordered by their appearance in the query
• Security updates

• Fix JNDI datasources not working in some cases.

• Fix JNDI datasources not working in some cases.

• Remove deprecated JSON path feature (see How to migrate from JSON Path to a Converter)
• Update converter JavaScript engine to support ES5+ syntax
• Ship JDBC libraries in artifact
• Bugfix: do not close preview dialog on outside clic

• Remove deprecated JSON path feature (see How to migrate from JSON Path to a Converter)
• Update converter JavaScript engine to support ES5+ syntax
• Ship JDBC libraries in artifact
• Bugfix: do not close preview dialog on outside click

• Implement new query wildcard @spacecategory that replaces query parameter with PocketQuery-specific space category value
• Make deprecation warning for JsonPath query field stronger
• Remove blue underline for delete icon
• Multiple security and stability improvements

• Implement new query wildcard @spacecategory that replaces query parameter with PocketQuery-specific space category value
• Make deprecation warning for JsonPath query field stronger
• Remove blue underline for delete icon
• Multiple security and stability improvements

• Fix issue with encoding of request headers

• Fix issue with encoding of request headers

• Fixes an issue with query parameters appearing twice in the draft preview dialog

• Fixes an issue with query parameters appearing twice in the draft preview dialog

• Error message text fix

• Error message text fix

• Fix Internet Explorer 11 Compatibility

• Fix Internet Explorer 11 Compatibility

More shared code between PocketQuery for Jira and PocketQuery for Confluence

More shared code between PocketQuery for Jira and PocketQuery for Confluence

• Disable query parameter validation for Preview button to make empty parameters possible
• Better error reporting for converter execution
• Internal restructuring of frontend architecture and standardization with Jira version

• Disable query parameter validation for Preview button to make empty parameters possible
• Better error reporting for converter execution
• Internal restructuring of frontend architecture and standardization with Jira version

• All code editors can now be toggled to fullscreen mode
• Webpack update to v5
• Admins cannot run queries in disallowed spaces anymore
• New warning message in admin when GSON fallback was applied
• Improved logging for cache (de-)serialization issues

• All code editors can now be toggled to fullscreen mode
• Webpack update to v5
• Admins cannot run queries in disallowed spaces anymore
• New warning message in admin when GSON fallback was applied
• Improved logging for cache (de-)serialization issues

• Improved logging
• Update to AUI9 (close button fix)
• Improve UX of restricted spaces

• Improved logging
• Update to AUI9 (close button fix)
• Improve UX of restricted spaces

• CSS fixes
• OAuth2 token refresh fix

• CSS fixes
• OAuth2 token refresh fix

• Entities in PocketQuery administration have tooltips
• App icons were updated

• Entities in PocketQuery administration have tooltips
• App icons were updated

• Fix request object not being passed to templates
• Fix edge case exception in wildcard replacements

• Fix request object not being passed to templates
• Fix edge case exception in wildcard replacements

Fix: internal storage deserialization edge case issue

Fix: internal storage deserialization edge case issue

• Feature: New global configuration flag to make “Spaces” field required for queries
• Fix: template method renderPocketQueryMacro does not require page parameter anymore
• Fix: pass parent template context to nested templates
• Fix: admin and editor groups can now be removed
• Improvement: show result from converter in debug screen
• Multiple minor fixes, improvements, refactorings

• Feature: New global configuration flag to make “Spaces” field required for queries
• Fix: template method renderPocketQueryMacro does not require page parameter anymore
• Fix: pass parent template context to nested templates
• Fix: admin and editor groups can now be removed
• Improvement: show result from converter in debug screen
• Multiple minor fixes, improvements, refactorings

• Fix issue with Word export

• Fix issue with Word export

Disable caching for preview queries

Disable caching for preview queries

• Fix issue with chart object in beforeDraw
• Fix issue with “Change” button and URL parameters
• Increase default cache size
• Clear draft query cache

• Fix issue with chart object in beforeDraw
• Fix issue with “Change” button and URL parameters
• Increase default cache size
• Clear draft query cache

• Added icons to better illustrate the responsibility of each PocketQuery entity type
• Added $PocketQuery.parseDate()
• Added $PocketQuery.getRandomUUID()

• Added icons to better illustrate the responsibility of each PocketQuery entity type
• Added $PocketQuery.parseDate()
• Added $PocketQuery.getRandomUUID()

Fix issue with query results not being shown to some users despite having permission.

Fix issue with query results not being shown to some users despite having permission.

Fixed documentation and support links

Fixed documentation and support links

Multiple minor bug fixes.

Multiple minor bug fixes.

• Rename Velocity template variable $mathTool back to $math
• Improve IE11 support

• Rename Velocity template variable $mathTool back to $math
• Improve IE11 support

• Renaming of entities and allowing more characters in names.
• New preview functionality in PocketQuery admin (using the same dialog as in admin).
• Revised macro browser (using the same dialog as in admin).
• PQ Admin link was moved from user menu to admin menu.
• Great number of code quality improvements, minor fixes, standalone frontend for developers (Handlebars, ES6, Webpack, etc.), and lots of major code base refactorings.
• Show PocketQuery entity CRUD actions in Confluence audit log.
• Query statistics are now shown by default in PQ admin.
• Many code quality improvements and bugfixes

• Renaming of entities and allowing more characters in names.
• New preview functionality in PocketQuery admin (using the same dialog as in admin).
• Revised macro browser (using the same dialog as in admin).
• PQ Admin link was moved from user menu to admin menu.
• Great number of code quality improvements, minor fixes, standalone frontend for developers (Handlebars, ES6, Webpack, etc.), and lots of major code base refactorings.
• Show PocketQuery entity CRUD actions in Confluence audit log.
• Query statistics are now shown by default in PQ admin.
• Many code quality improvements and bugfixes

Fix issue with “Not Permitted“ page

Fix issue with “Not Permitted“ page

• Fix links for related pages to bear context path
• Improve entity deserialization mechanism

• Fix links for related pages to bear context path
• Improve entity deserialization mechanism

• Make sure entity form URLs work in all environments
• Make sure test connection requests for REST datasources send GET requests
• Introduce detailed request/response logging on DEBUG level

• Make sure entity form URLs work in all environments
• Make sure test connection requests for REST datasources send GET requests
• Introduce detailed request/response logging on DEBUG level

• Bumped Google Charts to version 47
• Add $PocketQuery.getLocale() API for Templates
• Deprecate JSON Path
• Deprecate legacy Template parameters

• Bumped Google Charts to version 47
• Add $PocketQuery.getLocale() API for Templates
• Deprecate JSON Path
• Deprecate legacy Template parameters

Fixed platform dependencies with converter engine and improved performance of converter execution.

Fixed platform dependencies with converter engine and improved performance of converter execution.

Bugfix: reloading query with dynamic parameters and dynamic load triggered a page reload

Bugfix: reloading query with dynamic parameters and dynamic load triggered a page reload

Fix encoding issues with umlauts in converter and template descriptions

Fix encoding issues with umlauts in converter and template descriptions

• Update vendor images and app logos
• Update documentation and support links
• Remove obsolete macro help and admin help button in headers
• Remove obsolete resources

• Update vendor images and app logos
• Update documentation and support links
• Remove obsolete macro help and admin help button in headers
• Remove obsolete resources

• Feature: XML-based REST responses (see new Handling XML-based REST responses)
• Improvement: we introduced the concept of error codes that will be displayed in the PocketQuery admin when something is going wrong currently
• Improvement: more detailed logging in PQ REST service
• Bugfix: there was an unresolved variable $caughtException in the debug view of PQ macros
• Bugfix: some AUI icons were broken in newer Confluence versions
• Bugfix: incompatibility between PQ and Table of Content macro was resolved
• Bugfix: JavaScript errors in PQ admin with complex content in descriptions
• Bugfix: there was an occasional cache deserialization exception in the PocketQuery admin on some data center instances
• Bugfix: index job now handles problems occurring during indexing more gracefully
• Bugfix: there was an occasional NoClassDefFound error for Spring JDBC libraries

• Feature: XML-based REST responses (see new Handling XML-based REST responses)
• Improvement: we introduced the concept of error codes that will be displayed in the PocketQuery admin when something is going wrong currently
• Improvement: more detailed logging in PQ REST service
• Bugfix: there was an unresolved variable $caughtException in the debug view of PQ macros
• Bugfix: some AUI icons were broken in newer Confluence versions
• Bugfix: incompatibility between PQ and Table of Content macro was resolved
• Bugfix: JavaScript errors in PQ admin with complex content in descriptions
• Bugfix: there was an occasional cache deserialization exception in the PocketQuery admin on some data center instances
• Bugfix: index job now handles problems occurring during indexing more gracefully
• Bugfix: there was an occasional NoClassDefFound error for Spring JDBC libraries

There was a misleading error message referring to a field "paramtypes" displayed for errors with different root causes.

There was a misleading error message referring to a field "paramtypes" displayed for errors with different root causes.

Fix issue with “Not Permitted“ page.

Fix issue with “Not Permitted“ page.

• Feature: new description field for all PocketQuery entities
• Improvement: read-only mode for data center
• Improvement: PocketQuery.load undeprecated
• Bugfix: too strict request header validation for REST datasources
• Bugfix: JNDI datasource did not work in some versions of Tomcat

• Feature: new description field for all PocketQuery entities
• Improvement: read-only mode for data center
• Improvement: PocketQuery.load undeprecated
• Bugfix: too strict request header validation for REST datasources
• Bugfix: JNDI datasource did not work in some versions of Tomcat

Fixed issue with $PocketQuery.renderPocketQueryMacro helper method.

Fixed issue with $PocketQuery.renderPocketQueryMacro helper method.

• Bugfix: prevent automatic redirects for URLs that contain periods (".")
• Bugfix: make Google chart object available in `PocketQuery.chart` JavaScript method

• Bugfix: prevent automatic redirects for URLs that contain periods (".")
• Bugfix: make Google chart object available in `PocketQuery.chart` JavaScript method

We have finally implemented a feature that PocketQuery admins were asking for a long time: entity cloning! The cloning/copying of entities is a frequent process among administrators. Previously, this was achieved by a cumbersome copy/paste procedure. We now have a simple "clone" button for this purpose. Along with this feature we implemented a few improvements regarding security and compatibility with different JDKs.

• Implemented copying/cloning of entities in PocketQuery admin (queries, datasources, templates, converters)
• Added wildcard support for anonymous users.
• Fixed queries not rendering for anonymous user when debug mode is enabled.
• Added fallback mechanism for converter support when Nashorn engine is not available in JDK.
• Updated Google Chart loader to most recent version.
• Improved security for datasource passwords in admin UI.

We have finally implemented a feature that PocketQuery admins were asking for a long time: entity cloning! The cloning/copying of entities is a frequent process among administrators. Previously, this was achieved by a cumbersome copy/paste procedure. We now have a simple "clone" button for this purpose. Along with this feature we implemented a few improvements regarding security and compatibility with different JDKs.

• Implemented copying/cloning of entities in PocketQuery admin (queries, datasources, templates, converters)
• Added wildcard support for anonymous users.
• Fixed queries not rendering for anonymous user when debug mode is enabled.
• Added fallback mechanism for converter support when Nashorn engine is not available in JDK.
• Updated Google Chart loader to most recent version.
• Improved security for datasource passwords in admin UI.

• You can now configure timeouts and resource limits to the global PocketQuery configuration.
• Improved error message for when a REST result can't be interpreted as a table by PocketQuery.

Fix issue with “Not Permitted“ page.

Multiple PocketQuery administrators approached us with a requirement for more information in converters. With this release, converters will receive a second argument that contains different (meta-)information like query and macro parameters. This release also contains more technical improvements regarding robustness and stability that was driven by our work on the data center verification process. Finally, a comprehensible list of minor bugs have been addressed.

Points:

• More information available in converters
• Robustness and stability improvements
• A series of minor bugfixes

• Fix wiki markup compatibility
• Fix for cache key creation bug

• Fixed "Add results to Confluence search" checkbox not getting saved in some cases.

• Introduced PocketQuery CORE for cross product compatability (PocketQuery for JIRA is coming!). These are merely refactoring changes and won't be noticed from admin-/user-side.
• Adjusted styling of default template to look like the default Confluence table
• Fixed "add query" button not showing up in the PocketQuery admin after adding the first Datasource
• Fixed a rare NullPointerException for REST Custom Auth
• Fixed PocketQuery result indexing missing some columns
• Reintroduced a previously removed data-attribute (data-query) for compatibility with older templates

• Bugfix: Prevent unnecessary popup (when anonymous access on iPad)
• Bugfix: Improve parameter encoding and handling of special characters

• Import/export for single entities
• New user role: PocketQuery editors (that can maintain all entities except datasources)
• PocketQuery Macro Usage queries for deeper insights in your query usage statistics
• Several bugfixes, security and usability improvements
• Deprecated the function PocketQuery.load() of the JS API.

• Usage information for all PocketQuery entities
• Statistics on query usage (with advanced option)
• Improvement and Bugfix for Macro Browser

Please note: starting with this release, PocketQuery uses Active Objects

• Admin interface: Filter queries by datasource
• Support parameter wildcards (e.g. @pagetitle) in SQL and REST query statements

• Charts: support for Google Material Charts
• Charts: target container for chart can now be specified as configuration in PocketQuery.chart
• Charts: now only PocketQuery.chart(chartType, options) supported and other API patterns deprecated
• REST: new OAuth2 type (old OAuth type has issues with OAuth2)
• Layout: entity lists now have fixed height with scroll
• Layout: new and edited entities are now inserted alphabetically by name
• Layout: improved highlighting of selected list items and add buttons
• Layout: changes in entity form layout - name field is now first; big name field when adding entity; showing name as heading when editing entity

Fixed sorting on page load of entities in admin lists

• prevent encoding of quotes in JSON path field
• make "=" work in request parameters and headers
• show warning in PQ admin when no valid license

Major new features:

• REST APIs as new type of datasources
• New converter entity for transformation of results
• Administration redesign
• Confluence data center compatibility
• Minor improvements and bugfixes

See: https://www.scandio.de/blog/de/2017/01/please-welcome-pocketquery-3-0-for-confluence

• Now filtering entities such that no "null" items will appear when errors occurred
• Minor Confluence 6.0.1 style fix in preview mode with dynamic load

• Resizable columns work with Dynamic Load now
• Better compatibilty with mobile client
• Architectural JS improvements
• Confluence 5.10.6 and 6.x compatibility

Check out our news article on PocketQuery 2.1

• Group-based PocketQuery administration
• Query parameters of type Boolean
• Query parameters in SELECT clauses
• Render custom templates also when errors occured
• Deactivate auto-load for dynamic load

Bugfix: multiple charts and dynamic load now don't change containers

• It is now forbidden to use Java reflection in PocketQuery templates. For now, templates with reflection will still be run, but a big WARN message is logged. These templates will not be run anymore in PocketQuery 2.1!
• PageID in REST calls now also validated properly for drafts (dynamic load works again in preview)!
• Re-included $numberTool in custom templates

• JS methods queryColumns and queryJson now return data for current query if used without parameters
• beforeDraw callback function in pocketChart method

See PocketQuery 2.0 release article.

ID of the current page can now be passed to PocketQuery macro with @pageid wildcard in macro browser.

There is now a new template parameter "colresizable" that you can use to avoid making table columns resizable. This will avoid loading the ColResizable JS library.

Simply add this to the top of your template:## @param colresizable:false

• Improved PocketQuery.queryArray JS method
• Fixed issue with dates in Google Charts API

• Fixed horizontal scrollbars in IE in admin
• Fixed web resource module dependencies

Fixed icons-not-visible bug in admin area

Read our blog article for more detailed news on the improvements in this release!

• New icon design
• Template configuration
• PlainText output
• New helper methods renderXhtml and renderWikiMarkup
• Macro browser auto-focus
• Date format for Google Charts API
• Rearranged position in admin UI
• Design of help button

• Changed Google Charts inclusion pattern from excludes to includes. All packages will now be loaded without maintaining an array like "chartsNotInCore"
• Changed macro definition in atlassian-plugin.xml to xhtml-macro
• Included device-type mobile in macro definition. Macro will now render in mobile client.

Fixed layout issue with MacroBrowser: PocketQuery applies a class value for the MacroBrowser div that wasn't removed on close.

• Form for the 'change params template' now sends preset GET parameters to new request.
• PocketQuery templates are now rendered even if errors with query occured (also 'change params template').

• Fixed issue that colons in statements in single quotes are interpreted as parameters in macro browser.
• Fixed jQuery compatibility problem with jQuery.fn.prop for Confluence 4.0.x.

• Macro browser UI improvements.
• Macro parameter "Use change params template".
• New helper for Velocity templates.
• Override data for Google Charts.
• Several minor bugfixes and improvements.

• PocketQuery is now shipped as OBR due to Lucene compatibility dependencies
• Template fix for HTML entity encoding problem

• i18n changes due to macro browser redesign in Confluence 5.5.x
• Switched to Extractor workaround for better Lucene compatibility among Confluence versions

• Fixed Lucene compatibility issue and ensured backwards compatibility down to Confluence 4.0.
• Fixed CSS bug for "Advanced Editor" link in PocketQuery admin in Confluence 4.x.

Read our Blog article for a description of the features of PocketQuery 1.12!

• Indexing (new key feature): Confluence administrators can now enable indexing PocketQuery results query-wise on the PocketQuery admin page. If indexing for a query is enabled, its results will be searchable using the default Confluence search.
• Autocomplete for DB driver in admin now only when field is empty.
• Auto-Commit is now true by default for all JDBC connections made by PocketQuery.

• LogUtils and advanced logging functionality
• TestDatabase functionality improved
• Several CSS fixes for Confluence 4.x-5.x compatibility
• New template variables $date, $calendar, $dateFormatter, $friendlyDateFormatter