PLAYSQL-302 - We've tried to upgrade as many libraries as possible and make it compatible with Confluence 8.0.

This app reaches its end-of-life in 2 month, on December 31st 2022.

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, including the PostgreSQL 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-296 Make the Date Picker work in Confluence 7.2+.
• PLAYSQL-295 Make User Parameters work in pages when the loading is in "print" mode"

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

This version of Play SQL Spreadsheets comes with Play SQL Base compatible with Confluence 7.

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 from Excel

It is now possible to paste images in cells. See Release notes 3.1.0 for more information.

• PLAYSQL-252 Image renderer

PLAYSQL-253 Some customers may have had problems enabling the add-on after the last upgrade. This is now fixed, along with very tiny details in the setup wizard.

We're publishing relationships between tables. Please see the Confluence page or the Youtube video for more information.

• PLAYSQL-42 Foreign keys

PLAYSQL-251 Fix pasting issues:

• Typing or pasting into a cell should give the focus to that cell. Editing a cell required a click since the last revision, and it was a bug.
• Prevent popping out the drop-down when pasting several cells on a multiple-choice list.
• 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.

Those bugfixes have been corrected in Play SQL Base, which is included in Play SQL Spreadsheets and can be updated separately. This version only ensures new customers get the latest version of both by default.

It's all in the name. See the release notes about the charts.

• PLAYSQL-223 Change the tab "Database" of the setup to make it simpler.
• PLAYSQL-206 Use the PSEA add-on for exports, but don't require it. It makes installation simpler because UPM sometimes can't manage add-ons which depend on each other.
• Fix an error when displaying the Audit Trail.

• PLAYSQL-228 Fixed bug at installation.
• PLAYSQL-224 It wasn't possible to disable a connection, once it was saved as "JNDI" or "JDBC".

• PLAYSQL-125 Forms,
• 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. Compatible with 5.10.x 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.

See the Release Notes 2.11 for details.

• PLAYSQL-135 Permissions
• PLAYSQL-174 Excel export
• PLAYSQL-173 Removal of the legacy SQL macro
• PLAYSQL-172 Cell wrapping, column width and pagination improvements.

• PLAYSQL-165 Joint Tables can now use another column than the primary key.
• 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, joint tables are a powerful feature and they're becoming easier to build. Reordering columns, truncating a table and navigation will probably make a few of you happy.

• 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, duplication, deletion. Add breadcrumbs for old theme.
• PLAYSQL-144 Reorder columns
• PLAYSQL-145 Delete all contents of a table
• PLAYSQL-148 Add error message when typing letters in an integer column
• PLAYSQL-149 Allow selecting spreadsheets from other spaces
• PLAYSQL-152 Error message improvement
• PLAYSQL-153 Joint Tables: Automatically create the underlying comments table

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:

• Formulas
• Joint Tables (augmenting a read-only table with comments)
• Open-source dialects
• Create from the Create dialog
• New pricing

Technical note: There are schema changes in this version. It is safer to have a backup of Postgres before upgrading. More information in the 2.10 Upgrade Guide for system administrators.

• PLAYSQL-108 Provide an online database for non-Postgres houses
• PLAYSQL-117 Don't display the POSITION column when printing

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 - Requires PostgreSQL 9.2+
• PLAYSQL-97 Data Center support
• PLAYSQL-103 Translations

• PLAYSQL-94 Autofilters: Click on the header, select a filter... Done!
• PLAYSQL-96 Fix iconfont for Windows users (pagination icons)
• PLAYSQL-23 Link renderer for emails
• PLAYSQL-83 Jira issue rendering with link

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

User Parameters weren't displayed in the Macro Browser for Confluence 5.6.4. This release fixes it.

For more details, please see PLAYSQL-84.

For details on upcoming improvements, please see our blog post.

• PLAYSQL-65 Queries: Ability to remove the header
• PLAYSQL-66 Button to duplicate spreadsheets (Confluence 5.1+ only)

Important: Please upgrade to 2.3 before upgrading to superior versions.

• SQL Wizards, to write and learn SQL
• New colorful SQL editor

New in this release

See Release Notes for 2.3.1 and the video:

• PLAYSQL-33: Paste cells to create columns and rows

Fixed in this release

• It is now possible to edit a column name without using the menu:
  • First click: Select the column
  • Second click: Show the menu
  • Third click: Rename the column
• The right way to start editing a cell is to press Enter. If you start typing, Play SQL will attempt to catch the characters and write them into the cell. It doesn't work for the 'c', for example, which opens the "Create" dialog.