- PLAYSQL-279 Compatibility with Confluence 7
- PLAYSQL-281 and PLAYSQL-282 Fix formula's autocomplete.
Version history
3.1.4Confluence Server 6.6.16 - 7.1.12019-09-30Compatibility with Confluence 7 3.1.3Confluence Server 6.6.0 - 6.15.92019-05-27Maintenance release Compatibility with Confluence 6.15.4.
3.1.2Confluence Server 6.6.0 - 6.15.92019-01-29Remove the usage feedback job PLAYSQL-265 Since we don't get much information from the usage job, and although administrators could simply disable it, we've just removed it.
We've also removed the Heroku integration, since it was disabled a year ago.
3.1.1Confluence Server 6.6.0 - 6.14.32018-09-15Maintenance release PLAYSQL-257 Bug when pasting tables from Excel
3.1.0Confluence Server 6.6.0 - 6.11.22018-09-12Support for images in cells See the Release Notes 3.1 for more information.
- PLAYSQL-252 Image renderer
3.0.2Confluence Server 6.6.0 - 6.11.22018-09-03Maintenance release - PLAYSQL-255 Display the original SQL error message when possible, in the query editor.
- Compatibility with Confluence 6.12 (EAP)
3.0.1Confluence Server 6.6.0 - 6.11.22018-07-31Support for foreign keys - PLAYSQL-42 Support for foreign keys
- PLAYSQL-254 Compatibility with version 3.x of Play SQL Spreadsheets
2.13.13Confluence Server 6.6.0 - 6.10.32018-05-28Maintenance release PLAYSQL-251 Fix pasting issues:
- Pasting a table should transform it into a macro.
2.13.12Confluence Server 6.6.0 - 6.9.32018-03-03Maintenance release - Compatibility for Confluence 6.8,
- PLAYSQL-247 Ensure the user is warned if a database is created in read-only mode.
- PLAYSQL-42 Fix Javascript error related to foreign keys.
2.13.11Confluence Server 5.10.1 - 6.7.32017-12-14Maintenance Release and compatibility with Confluence 6.6 PLAYSQL-242 Fix bug when attempting to delete queries, spreadsheets, etc. Fix additional bugs with Javascript (charts, totals).
2.13.10Confluence Server 5.10.1 - 6.6.172017-12-14Maintenance Release PLAYSQL-242 Fix bug with the totals in Joint Tables (the webpage displayed them although they are not allowed).
2.13.9Confluence Server 5.10.1 - 6.5.32017-12-07Maintenance Release PLAYSQL-242 Javascript error when deleting an entry.
2.13.8Confluence Server 5.10.1 - 6.5.32017-12-06Maintenance release Fixed PLAYSQL-241 – Error when creating Joint Table
2.13.7Confluence Server 5.10.1 - 6.5.32017-11-06Maintenance release PLAYSQL-239 It isn't possible to select a query or a spreadsheet in the macros, because the drop-down is empty.
2.13.6Confluence Server 5.10.1 - 6.5.32017-11-01Maintenance Release and compatibility with Confluence 6.5.0 PLAYSQL-239 Another attempt at fixing the error in the Query Editor.
Compatibility with Confluence 6.5.0.
2.13.5Confluence Server 5.10.1 - 6.4.32017-10-31Maintenance release PLAYSQL-239 Another attempt at fixing the error in the Query Editor.
Also, improve the setup to require the administrator to test the connection before validating, so that the dialect is successfully detected.
2.13.4Confluence Server 5.10.1 - 6.4.32017-10-27Maintenance Release PLAYSQL-239 Another attempt at fixing the error in the Query Editor.
2.13.3Confluence Server 5.10.1 - 6.4.32017-10-27Maintenance Release PLAYSQL-239 Another attempt at fixing the error in the Query Editor.
2.13.2Confluence Server 5.10.1 - 6.4.32017-10-25Maintenance Release PLAYSQL-239 Fix a javascript error in the Query Editor (and provide a way of reporting such errors in one click).
2.13.1Confluence Server 5.10.1 - 6.4.32017-09-19Maintenance release PLAYSQL-236 Menus weren't visible when the RefinedWiki theme was used.
PLAYSQL-229 Fix error when there were several charts on the same page.
2.13.0Confluence Server 5.10.1 - 6.4.32017-09-06Charts It's all in the title and, yes, it's also for Play SQL Base. See the release notes about the charts.
2.12.5Confluence Server 5.9.1 - 6.3.42017-05-30Maintenance Release PLAYSQL-228 Fixed bug at installation.
2.12.4Confluence Server 5.9.1 - 6.2.42017-05-28Maintenance Release PLAYSQL-224 It wasn't possible to disable a connection, once it was saved as "JNDI" or "JDBC".
Previous releases of this add-on didn't include PSEA, which is required for Excel exports.
2.12.3Confluence Server 5.9.1 - 6.2.42017-05-25Maintenance Release PLAYSQL-224 It wasn't possible to disable a connection, once it was saved as "JNDI" or "JDBC".
2.12.2Confluence Server 5.9.1 - 6.2.42017-05-23Compatibility with Edge / IE11 / IE10 PLAYSQL-227 The previous version used new features of Javascript that aren't available for IE10 customers. We've reverted to the older language in order to keep the compatibility.
2.12.1Confluence Server 5.9.1 - 6.2.42017-05-17Confluence 6.2 compatibility See the release notes for the rest of the details:
- PLAYSQL-222 In the setup, we require a schema name when in spreadsheet mode (read-write).
- PLAYSQL-222 Fix the space drop-down in the setup. It lets you set different connection details for a given space than the global connection.
- PLAYSQL-219 Fix a bug with the User picker and Page picker for cells.
- PLAYSQL-218 Fix minor bugs for Internet explorer.
- PLAYSQL-194 Fix the row menu, which didn't appear in some configurations.
- PLAYSQL-206 We use an external plugin named "PSEA" to export to Excel. The plugin is shared between Play SQL and Requirement Yogi, which decreases the memory requirements by 15Mb for instances where both are installed. PSEA must be present, and is installed when Play SQL is installed.
2.11.7Confluence Server 5.9.1 - 6.1.42016-11-02Compatibility with Confluence 6.0 and maintenance - PLAYSQL-208 Compatibility with Confluence 6.0 and bugfix for Confluence Data Center.
- PLAYSQL-203 Require a dialect when administering a connection.
- PLAYSQL-202 In the setup, hide the Next button until the administrator saves the connection.
- PLAYSQL-201 Warn if the space key is not set in the macro (invisible, but necessary field – This happens when the macro is initially created on a global template).
- PLAYSQL-199 Change class names so we can install Bob Swift's plugin alongside Play SQL.
- PLAYSQL-193 Anonymous should be able to run queries, if the space permissions allow anonymous to see a page.
2.11.4Confluence Server 5.9.1 - 5.10.92015-12-02Compatibility with 5.10, Java 8 and JDBC 4.2 PLAYSQL-192 - Fix compatibility for Confluence 5.9.1 (compatibility with 5.10 too).
No feature change in this bugfix version.
Dear customers,
It has become difficult to provide comptability over both Java 7 and 8, and over several Confluence versions.
In this particular version, we had to drop compatibility with older versions of Confluence. Most customers who keep the add-on up-to-date also upgrade their Confluence instance from time to time, so we hope this will be minor inconvenience.
Going forward, we desire to keep the old policy: We maximize the backwards-compatibility when possible. It is only in this version that we've met particular difficulties. Thank you.
2.11.3Confluence Server 5.6.5 - 5.9.142015-10-21Bugfixes - PLAYSQL-184 Fix error when removing a connection (in the setup)
- PLAYSQL-185 Insert spreadsheets in global templates
2.11.1Confluence Server 5.3.1 - 5.8.182015-10-02Bugfix release - PLAYSQL-182 Ability to style PDF exports through custom CSS: Every macro has id & class attributes.
- PLAYSQL-176 Fix for the column aliases ('AS' keyword) in MySQL.
For Play SQL Spreadsheet (the paid version):
- PLAYSQL-183 Creating rows on a Joint Table across another space.
- PLAYSQL-158 Fix the position and size of the Page Picker and User Picker autocomplete drop-down,
- PLAYSQL-155 Fix the hyperlink of a Page Picker and User Picker when using [tab]; avoid saving them when unmodified.
2.11Confluence Server 5.3.1 - 5.8.182015-08-23Full screen and pagination improvement, Removal of the legacy SQL macro See the Release Notes 2.11 for details.
- PLAYSQL-173 Removal of the legacy SQL macro
- PLAYSQL-172 Cell wrapping, column width and pagination improvements.
2.10.10Confluence Server 5.3.1 - 5.8.182015-08-19Usability details: Copy/paste, pagination, full screen mode - PLAYSQL-157 Fixed a problem where rows couldn't be copied. However, in some situations, the user still needs to wait for 2 seconds before copying the row, otherwise nothing is copied.
- PLAYSQL-170 When the pagination is displayed, provide the ability to display all rows, reduce margins and go full-screen.
2.10.9Confluence Server 5.3.1 - 5.8.182015-07-282 Bugfixes - PLAYSQL-160 - Joint tables: Exception when creating a joint table
- PLAYSQL-157 - Replace $pageId in spreadsheet macro filter
2.10.8Confluence Server 5.3.1 - 5.8.182015-07-20UX Improvement release This release contains a few improvements which have been requested by several users. Especially, the navigation to/from the Query Editor was improved by a "Cancel" link and breadcrumbs for the Documentation Theme of Confluence.
- PLAYSQL-98 User Parameters: Allow blank default value
- PLAYSQL-151 User Parameters: Fix frozen value in page view
- PLAYSQL-139 Navigation: Add menu in the toolbar of the editor for cancellation. Add breadcrumbs for old theme.
I would personally also like to highlight:
- PostgreSQL makes it possible to embed read-only data from foreign databases, like MySQL (the feature is names Foreign Tables).
- Given a foreign, read-only table, you can augment it with comments/additional columns using the Joint Tables feature of Play SQL Spreadsheets.
- Notably, we've fixed: PLAYSQL-153 Automatically create the underlying comments table for Joint Tables.
2.10.7Confluence Server 5.3.1 - 5.8.182015-07-15Bugfix release (JNDI datasources and MySQL) PLAYSQL-141: Customer reported an problem when using Confluence 5.8.5 and JNDI datasources. It is due to a classpath issue when instantiating a datasource.
PLAYSQL-143: Fix an issue for MySQL about the database details. Also fix the autofilters/sort for MySQL.
2.10.4Confluence Server 5.3.1 - 5.8.182015-06-26Open-source dialects, create experience See the Release Notes 2.10 for Play SQL Spreadsheets:
- Dialects are now open-source. See Play SQL Dialects on BitBucket. Contributions are welcome, in order to extend vendor compatibility.
- New blueprint in the Create button in order to start a query.
2.9.1Confluence Server 5.3.1 - 5.8.182015-01-30Confluence 5.7 compatibility and bugfixing See the bug tracker for details:
- Confluence 5.7: Fix UI design,
- Confluence 5.7: Fix colliding keyboard shortcut and spreadsheet edition,
- Fix selecting text in cells,
- Fix the display port scrolling when editing a cell
- Fix changing a column's name
2.9Confluence Server 5.3.1 - 5.6.62014-12-09Enterprise release: Database Monitor and Data Center support See Release Notes 2.9 Enterprise and Data Center:
- PLAYSQL-13 Database Monitoring
- PLAYSQL-97 Data Center support
- PLAYSQL-103 Translations
2.8.3Confluence Server 5.3.1 - 5.6.62014-12-01Autofilters ! (see release notes) Highlight:
- PLAYSQL-94 Autofilters: Click on the header, select a filter... Done!
Bugfixing:
- PLAYSQL-96 Fix iconfont for Windows users (pagination icons)
- PLAYSQL-23 Link renderer for emails
- PLAYSQL-83 Link for Jira issues
2.8.1Confluence Server 5.3.1 - 5.6.62014-11-25Pagination & Bugfix - PLAYSQL-19 Pagination
- PLAYSQL-95 Fixed a bug where the space-level datasources aren't visible after restarting an instance.
2.8Confluence Server 5.3.1 - 5.6.62014-11-14Major rework: Display dollar amounts, resize columns, ... There are so many changes and improvements in this release that we hope to satisfy many long-standing user requests in one single version! See Release Notes 2.8.
Important: Confluence 5.3 and Java 7 are required.
- Queries can now use the same renderers as Spreadsheets,
- Rich / Static / Print layouts,
- User Parameters for queries,
- Upgrade of the system requirements,
- MySQL and Oracle users are still unsupported, but they have a specific dialect. A small configuration task is required for those users.
2.6.5Confluence Server 5.0 - 5.6.62014-05-04Small improvements release - PLAYSQL-65 Ability to remove the table header
2.6.3Confluence Server 5.0 - 5.4.4.rc12014-04-22Red cell, internationalization and default values in the legacy query - PLAYSQL-60 Hide the red cell
- PLAYSQL-59 Internationalization
- PLAYSQL-52 Default values in the legacy query
2.5Confluence Server 5.0 - 5.4.42013-12-14https://documentation.play-sql.com/display/PUBLIC/Release+Notes+2.5 New in this release
- SQL Wizards - Help your users get started writing queries thanks to the SQL wizards.
- Colorful SQL editor - It's so important to feel at home in your query editor!
- Table panel - On the right of the editor, browse tables and their columns in the panel.
2.2.1Confluence Server 5.0 - 5.3.42013-11-04Introducing Totals and publishing separately from Play SQL Spreadsheets