We are retiring this app next year on December 31st, 2022. See the announcement. This version:

• Updates compatibility with Confluence 7.15.0,
• Upgrades various libraries to the latest possible, notably the Postgres driver.

Re-publication of 3.2.0 with only the bugfixes and compatibility with Confluence 7.8.0.

• PLAYSQL-286 Export foreign key *values* to Excel along with the foreign key ID.
• PLAYSQL-276 Display 200 records by default, and keep the pagination widget visible when scrolling horizontally, so users don't believe it is the end of the table.

• PLAYSQL-295 Make User Parameters work on pages where the rendering is in "Print" mode.
• PLAYSQL-296 Make Date Pickers work in Confluence 7.2+. This requires Confluence 7.0.1 minimum.

PLAYSQL-292 The URL supports ?user-parameter-param1=... to set the value for the user parameter "$param1".

PLAYSQL-291 Avoid failure when a column was manually deleted between being "put to the bin" by the user and being effectively purged out of the audit trail.

PLAYSQL-290 Play SQL Forms can't be plugged with the previous version. 3.1.8 solves this issue by publishing the necessary package.

PLAYSQL-289 Fix the link to Jira issues

Fixed PLAYSQL-288 - Error with "Unable to resolve resource because it is exposed via two dependency chains." when running in Confluence 7.0 to 7.2.

• PLAYSQL-279 Compatibility with Confluence 7
• PLAYSQL-281 and PLAYSQL-282 Fix formula's autocomplete.

Compatibility with Confluence 6.15.4.

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.

PLAYSQL-257 Bug when pasting tables from Excel

See the Release Notes 3.1 for more information.

• PLAYSQL-252 Image renderer

• PLAYSQL-255 Display the original SQL error message when possible, in the query editor.
• Compatibility with Confluence 6.12 (EAP)

• PLAYSQL-42 Support for foreign keys
• PLAYSQL-254 Compatibility with version 3.x of Play SQL Spreadsheets

PLAYSQL-251 Fix pasting issues:

• Pasting a table should transform it into a macro.

• 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.

PLAYSQL-242 Fix bug when attempting to delete queries, spreadsheets, etc. Fix additional bugs with Javascript (charts, totals).

PLAYSQL-242 Fix bug with the totals in Joint Tables (the webpage displayed them although they are not allowed).

PLAYSQL-242 Javascript error when deleting an entry.

Fixed PLAYSQL-241 – Error when creating Joint Table

PLAYSQL-239 It isn't possible to select a query or a spreadsheet in the macros, because the drop-down is empty.

PLAYSQL-239 Another attempt at fixing the error in the Query Editor.

Compatibility with Confluence 6.5.0.

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.

PLAYSQL-239 Another attempt at fixing the error in the Query Editor.

PLAYSQL-239 Another attempt at fixing the error in the Query Editor.

PLAYSQL-239 Fix a javascript error in the Query Editor (and provide a way of reporting such errors in one click).

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.

It's all in the title and, yes, it's also for Play SQL Base. See the release notes about the charts.

PLAYSQL-228 Fixed bug at installation.

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.

PLAYSQL-224 It wasn't possible to disable a connection, once it was saved as "JNDI" or "JDBC".

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.

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.

• 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.

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.

• PLAYSQL-184 Fix error when removing a connection (in the setup)
• PLAYSQL-185 Insert spreadsheets in global templates

• 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.

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.

• 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.

• PLAYSQL-160 - Joint tables: Exception when creating a joint table
• PLAYSQL-157 - Replace $pageId in spreadsheet macro filter

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.

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.

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.

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

See Release Notes 2.9 Enterprise and Data Center:

• PLAYSQL-13 Database Monitoring
• PLAYSQL-97 Data Center support
• PLAYSQL-103 Translations

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

• PLAYSQL-19 Pagination
• PLAYSQL-95 Fixed a bug where the space-level datasources aren't visible after restarting an instance.

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.

• PLAYSQL-65 Ability to remove the table header

• PLAYSQL-60 Hide the red cell
• PLAYSQL-59 Internationalization
• PLAYSQL-52 Default values in the legacy query