https://appfire.atlassian.net/wiki/spaces/SQL/pages/282820785/Release+notes+-+Cloud+1.3.4
Version history
CloudConfluence Cloud2023-04-25Minor enhancements. App data is more secured 11.0.3Confluence Data Center 7.4.17 - 8.6.12023-11-03Minor security fixes No release notes.11.0.3Confluence Server 7.4.17 - 8.6.12023-11-03Minor security fixes No release notes.11.0.2Confluence Data Center 7.4.17 - 8.6.12023-10-26Compatible with Confluence 8.6 No release notes.11.0.2Confluence Server 7.4.17 - 8.6.12023-10-26Compatible with Confluence 8.6 No release notes.11.0.0Confluence Data Center 7.4.17 - 8.5.32023-02-23Compatibility with Confluence 8.x https://appfire.atlassian.net/wiki/spaces/SQL/pages/200901300/Release+notes+-+11.0.0
11.0.0Confluence Server 7.4.17 - 8.5.32023-02-23Compatibility with Confluence 8.x - https://appfire.atlassian.net/wiki/spaces/SQL/pages/200901300/Release+notes+-+11.0.0
10.4.6Confluence Data Center 7.0.1 - 7.20.32022-08-30Rebranding changes No release notes.10.4.6Confluence Server 7.0.1 - 7.20.32022-08-30Rebranding changes No release notes.10.4.5Confluence Data Center 6.13.0 - 7.19.162022-04-12Minor improvements and security fixes Security fixes and CCMA library changed from tracker to listener
10.4.5Confluence Server 6.13.0 - 7.19.162022-04-12Minor improvements and security fixes Security fixes and CCMA library changed from tracker to listener
10.4.4Confluence Data Center 6.13.0 - 7.17.52022-01-12Enhancements and Bug fixes No release notes.10.4.4Confluence Server 6.13.0 - 7.17.52022-01-12Enhancements and Bug fixes No release notes.10.4.2Confluence Data Center 6.13.0 - 7.15.32021-08-31Addressed minor defects Addressed minor defects
10.4.2Confluence Server 6.13.0 - 7.15.32021-08-31Addressed minor defects Addressed minor defects
10.4.1Confluence Data Center 6.13.0 - 7.13.202021-08-18Addressed minor issues Addressed minor issues
10.4.1Confluence Server 6.13.0 - 7.13.202021-08-18Addressed minor issues Addressed minor issues
10.4.0Confluence Data Center 6.13.0 - 7.12.52021-05-04Server to cloud Global Configuration migration support In this release:
- Integration with Confluence Cloud Migration Assistant (CCMA)
- Supports Global Configuration data migration
- Additional fixes
Read more in the full release notes.
10.4.0Confluence Server 6.13.0 - 7.12.52021-05-04Server to cloud Global Configuration migration support In this release:
- Integration with Confluence Cloud Migration Assistant (CCMA)
- Supports Global Configuration data migration
- Additional fixes
Read more in the full release notes.
10.3.1Confluence Data Center 6.13.0 - 7.12.52021-02-16Addressed bugs identified internally and reported by users Addressed bugs identified internally and reported by users
10.3.1Confluence Server 6.13.0 - 7.12.52021-02-16Addressed bugs identified internally and reported by users Addressed bugs identified internally and reported by users
10.3.0Confluence Data Center 6.13.0 - 7.11.22021-01-05Apply column filters to tables in Confluence In this release:
- Apply filters to columns to view specific table data
- Display data profiles drop-down menu options based on user permissions
- Additional improvements and fixes
Read more in the full release notes.
10.3.0Confluence Server 6.13.0 - 7.11.22021-01-05Apply column filters to tables in Confluence In this release:
- Apply filters to columns to view specific table data
- Display data profiles drop-down menu options based on user permissions
- Additional improvements and fixes
Read more in the full release notes.
10.2.0Confluence Data Center 6.11.0 - 7.10.22020-06-17Filter table data, define delimiter for exports, improved row and column styles. In version 10.2:
- Use search terms or regular expressions to filter table data
- Specify a custom file delimiter such as comma, tab, or semicolon to be used when table data is downloaded or exported
- Enforce user-defined CSS styles for rows and columns
Read more in the full release notes.
10.2.0Confluence Server 6.11.0 - 7.10.22020-06-17Filter table data, define delimiter for exports, improved row and column styles. In version 10.2:
- Use search terms or regular expressions to filter table data
- Specify a custom file delimiter such as comma, tab, or semicolon to be used when table data is downloaded or exported
- Enforce user-defined CSS styles for rows and columns
Read more in the full release notes.
10.1.1Confluence Data Center 6.5.0 - 7.5.22020-02-17Content on the page is inconsistent & data source profiles 1. Content on the page is inconsistent due to conflict in css classes
2. Unable to fetch data source profiles for the macro users
10.1.1Confluence Server 6.5.0 - 7.5.22020-02-17Content on the page is inconsistent & data source profiles 1. Content on the page is inconsistent due to conflict in css classes
2. Unable to fetch data source profiles for the macro users
10.1.0Confluence Data Center 6.5.0 - 7.3.52019-10-30View and select tables and columns from a data source within the macro editor In version 10.1:
- View the tables and columns that are available in a data source and use those values to build SQL statements right within the macro editor
Read more in the full release notes.
10.1.0Confluence Server 6.5.0 - 7.3.52019-10-30View and select tables and columns from a data source within the macro editor In version 10.1:
- View the tables and columns that are available in a data source and use those values to build SQL statements right within the macro editor
Read more in the full release notes.
10.0.1Confluence Data Center 6.0.1 - 7.0.52019-09-13SQL for Confluence (Pro Edition) is now compatible with Confluence 7.0 SQL for Confluence (Pro Edition) is now compatible with Confluence 7.0
10.0.1Confluence Server 6.0.1 - 7.0.52019-09-13SQL for Confluence (Pro Edition) is now compatible with Confluence 7.0 SQL for Confluence (Pro Edition) is now compatible with Confluence 7.0
10.0.0Confluence Data Center 6.0.1 - 6.15.102019-06-24Customize SQL data tables with ease using a new, more intuitive macro editor What’s new in v10.0?
- Run and format queries in a redesigned, form-based macro editor
- Apply advanced styling and formatting to your tables more easily
- Fine-tune your data tables faster with a collapsible preview tray
- Locate your saved, external SQL scripts in an improved menu
Read more in the full release notes.
10.0.0Confluence Server 6.0.1 - 6.15.102019-06-24Customize SQL data tables with ease using a new, more intuitive macro editor What’s new in v10.0?
- Run and format queries in a redesigned, form-based macro editor
- Apply advanced styling and formatting to your tables more easily
- Fine-tune your data tables faster with a collapsible preview tray
- Locate your saved, external SQL scripts in an improved menu
Read more in the full release notes.
9.2.0Confluence Data Center 6.0.1 - 6.15.102019-03-21This release includes several bug fixes. 9.2.0Confluence Server 6.0.1 - 6.15.102019-03-21This release includes several bug fixes. 9.1.0Confluence Data Center 6.0.1 - 6.15.102018-09-17Data Center approved app — performance & scale-tested We've made massive investments in infrastructure and testing frameworks for our Data Center apps to ensure that they will scale to meet the needs of your enterprise team. SQL for Confluence Data Center has been rigorously tested and vetted for consistent, efficient, and reliable performance at scale.
For more information, read the full release notes.
9.1.0Confluence Server 6.0.1 - 6.15.102018-09-17Minor fixes and Data Center approved version now available Our server apps have always been Data Center compatible, and with the release of Atlassian’s new Data Center approved apps program, we've made massive investments in additional infrastructure and testing frameworks for our Data Center apps to ensure that they will scale to meet the needs of enterprise teams. These apps have been rigorously tested and vetted for consistent, efficient, and reliable performance at scale.
If you’re currently using Confluence Data Center or thinking about upgrading, check out the Data Center approved version of SQL for Confluence Pro Edition.
Additionally, this release also includes some minor fixes.
For more information, read the full release notes.
9.0.1Confluence Server 6.0.1 - 6.11.22018-07-11Fixes What's new in version 9?
Configure your data sources with ease — We've completely redesigned the admin configuration page to make it easier to connect to your SQL databases. Say goodbye to messy strings and hello to a straightforward, form-based setup.
Monitor data source connections in real time — Ensure your data sources are set up correctly from the start and stay connected with enhanced editing and visual connectivity indicators.
Connect to unlimited data sources — There is no longer a limit to the number of data sources you can connect to and save. Yes, you read that right! Unlimited data sources = unlimited business intelligence insight.
Read more in the full release notes.
9.0.0Confluence Server 6.0.1 - 6.10.32018-06-07Configure unlimited data sources with ease and monitor connections in real time. What's new in version 9?
Configure your data sources with ease — We've completely redesigned the admin configuration page to make it easier to connect to your SQL databases. Say goodbye to messy strings and hello to a straightforward, form-based setup.
Monitor data source connections in real time — Ensure your data sources are set up correctly from the start and stay connected with enhanced editing and visual connectivity indicators.
Connect to unlimited data sources — There is no longer a limit to the number of data sources you can connect to and save. Yes, you read that right! Unlimited data sources = unlimited business intelligence insight.
Read more in the full release notes.
8.5.0Confluence Server 5.10.0 - 6.9.32017-12-06Added avgIgnoreZero column calculation other fixes. 8.4.0Confluence Server 5.8.2 - 6.5.32017-05-30Improved sticky table headers support and fixes 8.3.0Confluence Server 5.7 - 6.2.42016-11-23Allow export of table view to CSV, library updates, fixes 8.2.0Confluence Server 5.7 - 6.0.72016-10-03Confluence 6.0 support, updated libraries, fixes 8.1.0Confluence Server 5.5 - 5.10.92016-05-12Fixes 8.0.1Confluence Server 5.5 - 5.9.142015-10-27Confluence 5.9 support, remove RB dependencies, fixes 8.0.0Confluence Server 5.7 - 5.8.182015-10-21Confluence 5.9 support, remove RB dependencies Release Notes 8.0 (important!)
7.1.1Confluence Server 5.4.3 - 5.8.182015-03-07Fix to show data source profiles in drop-down list for non-administrators 7.1.0Confluence Server 5.4.3 - 5.7.42015-02-10Get started dialog, updated libraries 7.0.2Confluence Server 5.2 - 5.7.42015-03-08Fix to show data source profiles in drop-down list for non-administrators 7.0.1Confluence Server 5.2 - 5.7.42015-01-18Get started fix and improvement. Correct example configuration. 7.0.0Confluence Server 5.2 - 5.6.62014-11-25Requires Java 1.7. Data source picker, limit connections, retry support 6.5.0Confluence Server 5.2 - 5.6.62014-11-03Fixes - configuration save may be lost if login has expired 6.4.0Confluence Server 5.2 - 5.6.62014-09-04Option for space based macro security, options for SQL code display 6.3.0Confluence Server 4.3 - 5.6.62014-07-08Connection properties, more data source profiles, Data Center, interoperability 6.2.0Confluence Server 4.3 - 5.5.72014-04-17Format numeric or date column data, column styles, average a column 6.1.1Confluence Server 4.3 - 5.4.42014-04-07Security fix, updated library 6.1.0Confluence Server 5.3 - 5.4.42014-03-21Numerical formatting of total column, more control options, updated libraries 6.0.2Confluence Server 4.2 - 5.4.42013-09-23Critical fix for data source profile users SQL-237: Excessive perm gen memory use when using profile defined data sources. Application server defined data sources do not have a problem.
6.0.1Confluence Server 4.2 - 5.2.52013-08-02New sql-file macro, date sorting improvements New macro
A new macro called sql-file is provided to enable user scenarios related to macro-security. It only allows accessing specifically authorized scripts stored on the Confluence server file system. This provides more flexibility for administrators to selectively grant general access to the results of specific SQL scripts on pages without edit restrictions or with less restrictive edit restrictions. This is accomplished using standard Macro Security for Confluence parameter control configurations.
Macro security configuration example
The following allows the authorized.sql script located in the <confluence home>/script directory to be run from any page against any data source. No other SQL scripts can be run.
Examplesql-file=*ANY sql-file.datasource.*=*ANY sql-file.file.authorized.sql=*ANY
Date sorting improvements
- A new date sorting option - column type M
- Advanced date sorting bundled with plugin eliminating need for server install
- International language support
See Advanced date sorting for more details.
6.0.0Confluence Server 5.0 - 5.1.52013-08-02New sql-file macro, date sorting improvements New macro
A new macro called sql-file is provided to enable user scenarios related to macro-security. It only allows accessing specifically authorized scripts stored on the Confluence server file system. This provides more flexibility for administrators to selectively grant general access to the results of specific SQL scripts on pages without edit restrictions or with less restrictive edit restrictions. This is accomplished using standard Macro Security for Confluence parameter control configurations.
Macro security configuration example
The following allows the authorized.sql script located in the <confluence home>/script directory to be run from any page against any data source. No other SQL scripts can be run.
Examplesql-file=*ANY sql-file.datasource.*=*ANY sql-file.file.authorized.sql=*ANY
Date sorting improvements
- A new date sorting option - column type M
- Advanced date sorting bundled with plugin eliminating need for server install
- International language support
See Advanced date sorting for more details.
5.4.3Confluence Server 4.1 - 5.1.52013-06-12Update shared libraries No release notes.5.4.2Confluence Server 4.1 - 5.1.52013-05-31Security fix related to the macro security plugin No release notes.5.4.1Confluence Server 4.1 - 5.1.52013-04-29New installs may fail on Confluence 5.x Fix a dependency problem which may cause installs on Confluence 5.x to fail.
5.4.0Confluence Server 4.1 - 5.1.52013-04-27Fix for horizontal row orientation, improve configuration UI, improved macro security Improvements and Fixes
- Fix a regression error that caused a display problem with horizontal row orientation.
- Improve the look and usability of the configuration display especially on Confluence 4.x.
- Improve macro security use by allowing user based page restrictions for a member of an authorized group.
5.3.0Confluence Server 4.1 - 5.1.52013-03-29Security fix related to macro security This release fixes a security exposure for customer using Macro Security for Confluence to secure use of the sql macros.
5.2.0Confluence Server 4.1 - 5.1.52013-02-12Dynamic data sources, before and after SQL, XHTML output Dynamic Data Sources
Administrators can now configure a data source via plugin configuration. These are referred to as data source profiles. These can be used just like the normal application server defined data sources. A key benefit is that a server restart is not required to make the data source active for use by macros. From a macro use perspective, they can be referenced just like application server datasources.
Before and After SQL
Data source profiles can add before and after SQL that automatically gets inserted around the macro defined SQL.
Data Source Alias
Macros can reference a data source (dataSource parameter) that gets redirected to a specific application server data source defined by the administrator. The benefit of this is to make it easier to migrate to a differently named data source.
XHTML Output
SQL that wants to generate XHTML output can use an new output parameter value of xhtml. The result will be rendered as XHTML before display.
CSS parameters
Additional parameters to control table class, table style, and row styles. Unique row styles can be set for the heading rows, and any number of data rows. Row styles for data rows repeat when the number of data rows exceeds the number of row styles. This allows various kinds of stripping.
5.1.0Confluence Server 4.1 - 4.3.72012-11-18Improved logging and query timeout support 5.0.1Confluence Server 4.1 - 4.3.72012-10-19Workaround Confluence editor inserting invalid character in body Affects sql macros created with the editor that reference an attachment or similar without any body content. See SQL-171. Does not affect wiki markup macros.
5.0.0Confluence Server 4.1 - 4.3.72012-09-18Native Confluence 4.x macros Confluence 4.x Native Macros
Native macros available in the Macro Browser. Confluence 3.x wiki macros are still supported.
Accommodate Confluence 4.3 Template Changes
Confluence 4.3 has storage space based templates. This incompatibility means that script support that gets text from a space template is broken since the returned content is now storage format. To accommodate this problem, change the handling of this data to look for unformated text in the template. Consider any content that is wrapped in a noformat or wiki-markup (CWP:Wiki Plugin for Confluence) as the plain content from the template. All other data in the template will be ignored.
The incompatibility requires templates that are used for this capability to be updated to surround the text with the noformat or wiki-markup macros. Most standard usage does not employ this technique, however some SQL users do use this extensively. To ease migration pains, support has been added for releases previous to Confluence 4.3 to allow the accommodation as well. In this case the noformat macro must be the first and last text in the template. This is supported by SQL plugin release 5.0.0 and later as well as 4.5.0 (for Confluence 3.5.x specifically).
Confluence 4.3 Column Sorting
Confluence 4.3 introduced some column sorting capability. This interferes with sql table support. Fortunately, Confluence developers provided a capability to disable this behavior for specific tables. This support is used for tables wrapped with sql, table-plus, csv, and similar macros supporting Common table capabilities
4.5.0Confluence Server 3.5 - 3.5.172012-09-18Accomodate Confluence 4.3 templates and other improvements Likely the last release supporting Confluence 3.x. See Compatibility - Confluence.
This release is roughly equivalent to the 5.0.0 release except for Confuence 4.x specifics.
4.4.0Confluence Server 3.5 - 4.3.72012-08-25Critical fix for SQL-163 - Critical fix: SQL-163 - SQL tables not sorting. Needed for users running plugin version 4.3.0 and 4.3.1.
- Other improvements
4.3.1Confluence Server 3.5 - 4.2.82012-08-15SQL-156 - bad interaction with chart macro No release notes.4.3.0Confluence Server 3.5 - 4.2.82012-07-19Allow unrenderedWiki as an output format. - Allow output=unrenderedWiki for advanced use.
- Update to latest level of common code.
Note: Full Confluence 4.x native compatibility will be available in version 5.0 to be released in the near future.
Now an Atlassian paid plugin - see this announcement.
4.2.2Confluence Server 3.1 - 4.2.122012-01-17SQL-134 fix 4.2.1Confluence Server 3.1 - 4.0.52011-08-28SQL-125 fix 4.2.0Confluence Server 3.1 - 3.5.172011-05-08Global config option for anti-XSS No release notes.4.1.0Confluence Server 3.1 - 3.5.172011-02-073.1+ support, XSS fixes, minor performance improvement 4.0.2Confluence Server 2.9 - 3.4.92011-02-05SQL-103 4.0.1Confluence Server 2.9 - 3.4.92010-04-10Add missing sort icons 4.0.0Confluence Server 2.9 - 3.2.12010-02-19Limit rows processed, sql logging, macro browser, i18n 3.6.0Confluence Server 2.9 - 3.1.22009-10-04Confluence 3.0 fixes, remote API fix 3.5.0Confluence Server 2.5.2 - 3.0.22009-01-04Released on 2009-01-04 {jiraissues:url=http://developer.atlassian.com/jira/secure/IssueNavigator.jspa?view=rss&pid=10147&fixfor=11616&sorter/field=issuekey&sorter/order=DESC&tempMax=25&reset=true&decorator=none|columns=key,priority,summary,updated,asignee,reporter,status|renderMode=static}
3.4.0Confluence Server 2.5.2 - 2.10.42008-04-25Released on 2008-04-25 {jiraissues:url=http://developer.atlassian.com/jira/secure/IssueNavigator.jspa?view=rss&pid=10147&fixfor=11450&sorter/field=issuekey&sorter/order=DESC&tempMax=25&reset=true&decorator=none|columns=key,priority,summary,updated,asignee,reporter,status|renderMode=static}3.3.0Confluence Server 2.4.2 - 2.10.42007-06-22Released on 2007-06-22 {jiraissues:url=http://developer.atlassian.com/jira/secure/IssueNavigator.jspa?view=rss&pid=10147&fixfor=10410&sorter/field=issuekey&sorter/order=DESC&tempMax=25&reset=true&decorator=none|columns=key,priority,summary,updated,asignee,reporter,status|renderMode=static}3.2.2Confluence Server 2.2.3 - 2.10.42007-05-13Released on 2007-05-13 {jiraissues:url=http://developer.atlassian.com/jira/secure/IssueNavigator.jspa?view=rss&pid=10147&fixfor=10505&sorter/field=issuekey&sorter/order=DESC&tempMax=25&reset=true&decorator=none|columns=key,priority,summary,updated,asignee,reporter,status|renderMode=static}3.2.1Confluence Server 2.2.3 - 2.10.42007-03-25Released on 2007-03-25 {jiraissues:url=http://developer.atlassian.com/jira/secure/IssueNavigator.jspa?view=rss&pid=10147&fixfor=10427&sorter/field=issuekey&sorter/order=DESC&tempMax=25&reset=true&decorator=none|columns=key,priority,summary,updated,asignee,reporter,status|renderMode=static}3.2Confluence Server 2.2.3 - 2.10.42007-03-04Released on 2007-03-04 {jiraissues:url=http://developer.atlassian.com/jira/secure/IssueNavigator.jspa?view=rss&pid=10147&fixfor=10385&sorter/field=issuekey&sorter/order=DESC&tempMax=25&reset=true&decorator=none|columns=key,priority,summary,updated,asignee,reporter,status|renderMode=static}3.1Confluence Server 2.2.3 - 2.10.42007-01-08Released on 2007-01-08 {jiraissues:url=http://developer.atlassian.com/jira/secure/IssueNavigator.jspa?view=rss&pid=10147&fixfor=10313&sorter/field=issuekey&sorter/order=DESC&tempMax=25&reset=true&decorator=none|columns=key,priority,summary,updated,asignee,reporter,status|renderMode=static}3.0.1Confluence Server 2.2 - 2.10.42006-09-26Released on 2006-09-26 No release notes.3.0Confluence Server 2.2 - 2.10.42006-09-24Released on 2006-09-24 {jiraissues:url=http://developer.atlassian.com/jira/secure/IssueNavigator.jspa?view=rss&pid=10147&fixfor=10216&sorter/field=issuekey&sorter/order=DESC&tempMax=25&reset=true&decorator=none|columns=key,priority,summary,updated,asignee,reporter,status|renderMode=static}