Page Comparison

Use the available select lists to select the tables, views and respective columns, and add them to your SQL statement. You can:

• Build simple queries by selecting the tables, views and/or columns, and clicking the add icon, or
• Enter your own SQL statement and add tables, views, and columns from the select lists wherever required in the query, or
• Add additional SQL scripts from the SQL script tab

The tables, views, and columns in the select lists are loaded based on the Data source profile selected. There is no limit to the number of statements you can run.

SQL script

Specifies the list of options where SQL scripts are located. The results will be based on the scripts present in the selected location.

• Attachment - The script is read from the list of options selected for the following parameters:
  • Space - Lists all available spaces.
  • Page - Lists all the pages available from the selected space.
    The following options indicate:
    • @self - current space or page

    • @home - homepage of current space

    • @parent - parent page of current page or space

• Template - Scripts is read from a global page template specified in the 'Name of the template' field. 

 Special note: How to deal with templates on Confluence 4.3 and later.

• Filename - The script is read from the input specified in the 'File name' field. You can specify the file located in confluence home directory/script/filename, also subdirectories.
• File encoding - Encoding for an external file if different from the system default handling. Default file encoding is UTF8.

Click + Add parameter (s) to create a set of optional data parameters to refine your SQL statements during runtime.

Each parameter field allows you to create a set of optional data parameters to refine your query. Parameters apply to your SQL statements during runtime. Simply enter the number of parameters you want to create in the Start with parameter (s) field and click + Add parameter (s) to define the parameters. You can define multiple parameters by clicking + Add value; there is no limit to the number of parameters you can add.

For example,

select * from example where name = ? or  department = ?

Most DBMSs offer a number of transaction isolation levels, which control the degree of locking that occurs when selecting data. You can select among a list of 5 kinds of transaction isolation levels:

• Read committed
• Read uncommitted
• Repeatable read
• Serializable: This is the highest isolation level.
• None: Skips adding any controls while your data is being selected. 

To know more about what you can do with each type, refer to Wikipedia: Isolation or See your database documentation.

Specify the upper limit for the number of rows your SQL query returns. Administrators can configure the limit.

Time in seconds that a query runs before a forced timeout. The default value is set by your Confluence administrator in the global configuration for SQL for Confluence. Since 5.1.

Specifies how the output is formatted:

• HTML - Generates HTML from the result set. Data is HTML encoded unless data encoding is disabled.
• XHTML (Pro Edition) - Generates and renders XHTML from the result set. Data is HTML encoded unless encoding has been disabled (disableAntiXss).
• Wiki - Generates and renders wiki markup from the result set. If the data contains unintended wiki markup characters, set the escape parameter On.
• unrenderedWiki (Pro Edition) - Generates wiki markup from the result set, similar to wiki, without rendering. Wraps with a table-plus macro suitable for copying to another system.