Version history
1.0.43Confluence Server 5.6.3 - 8.7.22022-11-24Compatibility list updated up to Confluence versions 7.20.2 No release notes.1.0.42Confluence Server 5.6.3 - 7.17.52022-05-11New features and minor improvements 1. added ability to wrap values in the specified columns (a new per SQL query configuration parameter)
2. added support for centered output layout
3. added ability to indicate columns that must be excluded from auto merging (relevant only when "Auto-merge Cells Strategy" is set to "Merge Within Columns") (a new per SQL query configuration parameter)
1.0.41Confluence Server 5.6.3 - 7.13.202021-09-21New features and bug fixes - per SQL query configuration: support for arbitrary notes added. The notes can be defined for each SQL query and will be displayed along with the results of this SQL query. See: Per SQL Query Configuration "notes" property in the user's guide.
- bug fixes and improvements
1.0.40Confluence Server 5.6.3 - 7.12.52021-04-12New features and bug fixing - user macro "Split Table into Several" added
- option "Documentation" added to "Bring Results As" param. New params under this option:
- "Result Format Options" param with 2 options:
- by default - display each row as the doc section
- "Tables from Rows" - display each row of the output table as separate table.
- "Column Index to Use as Header" - title the sections using this column value
- "Keep Header Column Within Section" - keep the header column within the section
- "Display Column Name Within Header" - display the column name within header too
- "Insert Page Breaks" - used to print 1 table per page
- "Wrap Result with Table" - additionally wrap the result with table
- "Allow Inner Tables Selection" - allow/disallow inner tables selection
- "Output Layout" - aligns results to right/left if needed
New per SQL-query configuration options added:
- "result_format_option"
- "column_index_to_be_used_as_header"
- "keep_header_column_within_section"
- "display_column_name_within_header"
1.0.39Confluence Server 5.6.3 - 7.10.22020-12-28New features - you can indicate the path to specific JSON array that you need to be selected in the input JSON input
- you can indicate the CSV separator used in the input CSV data- you can indicate that the data located by the URL is compressed using zip and you want to extract and process only the specific file from the archive
- new input parameter supported: "Case Sensitive Column Names" - enable it to use strict case sensitivity for column names (exactly as in the source data)
1.0.38Confluence Server 5.6.3 - 7.7.42020-08-21Critical bug fix Fixed hanging plugin preview UI in some later versions of Confluence
1.0.37Confluence Server 5.6.3 - 7.7.42020-08-19New features and bug fixing 1. Support conversion of results to ordered/unordered HTML list (use the new option "CSV as List" of the parameter "Bring Results As" and "Ordered List" checkbox to toggle ordered/unordered list output).
2. Support a new option for per SQL query configuration parameter bring_result_as. Use "bring_result_as":"Nothing" to execute the SQL query, but don't display any results.
1.0.36Confluence Server 5.6.3 - 7.6.32020-07-28New features and bug fixing 1. Support for JSON array output. If you want your results be formatted as JSON array - select the new option "JSON Array" of the configuration parameter "Bring Results As".
2. Support for new "bring_result_as" per SQL query configuration parameter (override for the global setting). You are able to specify the result output format for each query individually.
3. Helper Snippets codes updated.
4. Minor bug fixes.
1.0.35Confluence Server 5.6.3 - 7.5.22020-06-01New features and bug fixes - support for JSON format as input data added: you can put JSON directly into macro container or load it by a remote URL
- specify/override the format to be used for attachments used as input data for the tables
- bug fixing
1.0.34Confluence Server 5.6.3 - 7.4.182020-05-14New features and bug fixed 1. when preparing a table for the in-memory DB top adjacent horizontal headers will be normalized to 1 horizontal header (column titles will be concatenated). Other horizontal headers will be treated as data rows.2. For Input Body Type="List of URLs": you can add set_base_target=<> query parameter into URL to force all anchors, processed by the plugin from this URL, use the desired target attribute. For example, to force all links to open in a new window append: ?set_base_target=_blank to the desired source URLs in your list.3. Encoding bug fixed.
1.0.33Confluence Server 5.6.3 - 7.3.52020-03-18new features and bug fix - tables from Office Word and Office Excel inner macros are now supported as input tables for SQL-based Table Transformer macro
1.0.32Confluence Server 5.6.3 - 7.3.52020-02-10minor bug fix No release notes.1.0.31Confluence Server 5.6.3 - 7.3.52020-02-08new capabilities and bug fixing - "Input Body Type" configuration selector now supports "Direct Text" option: if the option is selected, the Macro will attempt treating the text within the container as 1 column table, wherein the first line of the text will become the column header, all other lines will become the rows in this column.
1.0.30Confluence Server 5.6.3 - 6.15.102019-11-08Bug fixing - minor bug fixes
- now one can nest Attachments macro within Table Transformer Macro and use the Attachments macro data as input data for the Transformer macro
1.0.29Confluence Server 5.6.3 - 6.15.102019-09-27New capabilities, UI and code improvements, bug fixes - SQL Query Editor flow and UI improvements and snippets updates.
- irrelevant input parameters in the UI will now dynamically hide/show depending on other settings.
- new input parameter "Base URI" that is used when "Input Body Type" is set to "Direct HTML". Defines base URI to be used for the HTML.
- when "Input Body Type" is set to "List of URLs", the content that gets fetched from a URL is handled as "UTF-8" charset by default. However, if needed, now this can be overridden by adding "use_charset" parameter to the URL.
1.0.28Confluence Server 5.6.3 - 6.15.102019-09-17Major UI and capability improvements Input:
- Input Tables can now have merged cells (both horizontal and vertical) Input params UI changes:
- params are grouped into tabs
- only the relevant params kept enabled
- auto-refresh preview
- SQL syntax highlighting and suggestions
- SQL Query input snippets New input params:
- Pre-rotate Input Tables: Select to pre-rotate input tables clockwise.
- Output Columns Order Options: Select an option for Columns order in the output tables.
- Post-rotate Output Tables: Select the angle to post-rotate all output tables CW.
- Auto-merge Cells of Result Tables: Enable to auto-merge equal adjacent cells.
- Auto-merge Cells Strategy New Per SQL Query Configuration parameters:
- auto_merge_cells_of_result_table: Overrides the global "Auto-merge Cells of Result Tables" Input Parameter.
- post_rotate_output_tables: Overrides the global "Post-rotate Output Tables" Input Parameter.
- output_columns_order_options: Overrides the global "Output Columns Order Options" Input Parameter.
1.0.27Confluence Server 5.6.3 - 6.15.102019-07-30Bug fix SQL query splitter inside /* */ comments will now be ignored.
1.0.26Confluence Server 5.6.3 - 6.15.102018-10-18Bug fix - Direct CSV is now properly parsed from the Macro Contaner
1.0.25Confluence Server 5.6.3 - 6.12.42018-10-06New capabilities 1. New Input Parameter "Input Body Type" - allows to select the type of the content that you are going to place inside the macro container (for ex., if you want to parse direct HTML code, set to "Direct HTML")
2. When the "Input Body Type" is set to "List of URLs", HTML, CSV or JIRA Table formatted data can be fetched by the macro from direct URLs. You can mix different formats within the list or use Wiki paths to versions of pages or attachments.
3. "Resolve Wiki Paths in Query" Input Parameter has been renamed to "Resolve Wiki Paths in Input URLs"
4. New Input Parameter "Show Customization" - enable to present all customized input parameters with values (i.e. those, that differ from the defaults). Useful mostly for demonstration purposes and/or while tuning the macro.
See User's Guide for further details.
1.0.24Confluence Server 5.6.3 - 6.11.22018-09-25Code improvements. New input parameter added Tables Selector Tables Selector input parameter added - defines tables to be parsed within the container content. The parameter uses CSS Query selector format. For example, if you want to parse some external HTML, then you will need to specify custom tables selector. If in doubt - leave defaults. If empty, then defaults will be applied, i.e. selection of conventional Confluence tables and JIRA Issues/Filter macro-generated tables.
1.0.23Confluence Server 5.6.3 - 6.11.22018-09-21Code improvements and new features - New Input Parameter "Escape HTML": enable to escape HTML in results so that HTML codes are displayed in the Browser.
- Added support for Per SQL Query Configuration through JSON within SQL Query comment, such as: /*{...}*/.2 experimental Per SQL Query Configuration parameters are now supported: hide_table_header, use_confluence_class.
For further details please see User's Guide and Examples found on SQL Table Transformer Home Page
1.0.22Confluence Server 5.6.3 - 6.11.22018-09-19Support for new configuration parameters added - Include CSV Column Names: used only with "Bring Results As" set to one of CSV formats. Enable to include column names into the result
- Remove Spaces from CSV: used only with "Bring Results As" set to one of CSV formats. Enable to remove spaces from the result
- Quote All CSV Values: used only with "Bring Results As" set to one of CSV formats. Enable to quote all CSV values in the result
- CSV Separator: used only with "Bring Results As" set to one of CSV formats. Indicate which separator to use in CSV
- CSV Quote Character: used only with "Bring Results As" set to one of CSV formats. Indicate which quote char to use in CSV
- CSV Escape Character: used only with "Bring Results As" set to one of CSV formats. Indicate escape char to use in CSV
- CSV Line End: used only with "Bring Results As" set to one of CSV formats. Indicate line ending to use in CSV
- Preformat Result: used only when "Bring Results As" is NOT set to "Table" AND "Wrap Result With Code-Block" is disabled: Enable to preformat result
1.0.21Confluence Server 5.6.3 - 6.11.22018-09-17Bug fix Fixed Confluence xhml parser exception
1.0.20Confluence Server 5.6.3 - 6.11.22018-09-17New input parameters and result output formats Each result can now be output in 2 additional formats:
- CSV - convert results to CSV that can be directly copy/pasted to a file and used in MS Excel or OpenOffice Calc, etc.
- JSON - results will be presented as JSON.
New input parameters:
- Bring Results As - Select the format of the output results (Table, JSON, CSV).
- Path[s] to Element - used together with JSON format - you can indicate which element of the JSON you want to see as the result.
- Strip HTML Tags - use to remove HTML code from the results if needed.
- Wrap Result With Expand - use to wrap results with Expand macro.
- Wrap Result With Code-Block - use to wrap JSON or CSV format results.
- Result Code-Block Wrapper Language - if needed, tunes the code-block language for the results.
- Collapse Code-Blocks - use to collapse code blocks if any within the macro.
- Show Code-Block Title - use to show generic titles for any code-block within the macro.
- Show Code-Block Line Numbers - use to show line numbers in any code-block within the macro.
1.0.19Confluence Server 5.6.3 - 6.11.22018-09-06Transform Tables, obtained by JIRA Issues/Filter Plugin too Starting from this version you can use tables, created by JIRA Issues/Filter plugin, within the SQL Table Transformer macro container. This allows to:
- create multiple views, based on the same dataset, obtained from JIRA.
- compare/analyze datasets from the same or different connected instances of JIRA.
- compare/analyze JIRA datasets against other non JIRA tables, included into container or created by the macro during execution (such as, auto-created from a remote or attached csv).
- etc.
For further info visit: SQL Table Transformer for Confluence
1.0.18Confluence Server 5.6.3 - 6.10.32018-08-30Minor improvements - temp files cleanup on exit improved
1.0.17Confluence Server 5.6.3 - 6.10.32018-08-29Minor improvements - single quotes can now be escaped in Wiki path for SCVREAD and FILE_READ as double single quote ''.
- #attachmentVersionNumber can be omited in Wiki path (current version of the attachment will be assumed)
1.0.16Confluence Server 5.6.3 - 6.10.32018-08-28Support for new input parameter "Resolve Wiki Paths in Query" and functionality Introduces new input parameter "Resolve Wiki Paths in Query". Some H2 functions, such as CSVREAD and FILE_READ deal with file paths. This parameter enables support and auto-resolution of Wiki-formatted paths to attachments in SQL Queries, so that those could be understood by the functions. The format of a Wiki path is: "spaceKey:pageTitle^attachmentFilename#attachmentVersionNumber"
For example to create and display a table from an attached csv file you can use 2 SQL Queries:
CREATE TABLE temp_1 AS SELECT * FROM CSVREAD(':^example.csv#0');
SELECT * FROM temp_1
where ':^example.csv#0' is the latest version of the example.csv, attached to current page.
For further info visit: SQL Table Transformer for Confluence
1.0.15Confluence Server 5.6.3 - 6.10.32018-08-27Minor fix - fixed data isolation of multiple plugin instances while being executed simultaneously. Now each instance uses its private DB.