Description
Before migrating your SQL for Confluence app content from server to cloud, we recommend reading this Atlassian article to plan your migration.
Note |
---|
Administrators must ensure that the following feature flag is enabled in the server instance as a part of the pre-migration setup:
Refer to the Getting started page from Atlassian for more information about the prerequisites for the migration. |
...
Out of the macros available in the server/DC version, only the SQL Query macro is supported in the cloud version for this release. The following table lists the macro parameters and features that work differently in server/DC and cloud:
Configuration type (Global, Profile, or Macro) | Parameter/Feature | Server/DC | Cloud | Notes |
---|---|---|---|---|
Global | Disable anti-XSS mode | Supported | Not supported | |
Rows per page | Not supported | Supported | ||
Profile | Driver class/Driver JAR location | Supported | Not supported | |
Limit max active | Supported | Not supported | ||
Connection string | Supported | Not supported | ||
Show SQL option | Supported | Not supported | ||
Execution of multiple SQL statements (Initial SQL/Before SQL/After SQL) | Supported | Not supported | Due to technical limitations, the app currently does not support handling of multiple SQL statements in the cloud version. | |
AWS IAM user authentication method (AWS IAM/ AWS region/ Key ID/Secret Access Key) | Not supported | Supported | ||
Application server based data source profiles | Supported | Not applicable | ||
Macro | Default profile option | Supported | Not supported | |
Parameters/Auto commit SQL statements | Supported | Not supported | ||
Options for showing SQL code | Supported | Not applicable | In the cloud version, the macro displays SQL statements or scripts in the SQL format. Thus, the parameter is not required in the cloud version. | |
Output format | Supported | Not supported | ||
Show results as a table | Supported | Not supported | ||
Show number of rows updated | Supported | Not supported | ||
Wiki markup related fields (Render wiki markup macros in body/Show generated wiki markup/Escape special wiki characters) | Supported | Not applicable | This feature is not supported in Confluence cloud. | |
Stop encoding HTML characters | Supported | Not supported | ||
Expand array fields | Supported | Not supported | ||
Table styles related fields (Table id/Table class/Table style/Table width/Border width) | Supported | Not supported | ||
Enable download and export as an attachment/File delimiter... | Supported | Not supported | ||
Column type/Column attributes/Apply column attributes to header rows | Supported | Not supported | ||
Total type | Supported | Not supported | ||
Auto number column styles | Supported | Not supported | ||
Sorting related fields (Enable sorting on auto number column/Enable column sorting/Automatically sort in descending order/Display sort icon/Sort tip text) | Supported | Not supported | ||
Auto total numeric columns | Supported | Not supported | ||
Apply Column styles to column cells/Apply Row styles to row cells/Retain row style order after re-sorting | Supported | Not applicable | In the cloud version, the table in the Preview pane itself supports styling of specific row(s) and column(s). Thus, the specified parameters are not applicable for use in the cloud version. | |
Number of header rows/Header row styles | Supported | Not supported | ||
Enable row highlighting on mouse over | Supported | Not supported | ||
Highlight colour | Supported | Not applicable | In the cloud version, the table in the Preview pane itself supports highlighting of rows and columns. Thus, the specified parameter is not applicable for use in the cloud version. | |
Number of rows to be displayed on one page | Not supported | Supported |
Please note that all the other parameters function the same in both versions of the app.
...