Versions Compared

Old Version 13

changes.mady.by.user Saumya Sunder (Inactive) (Deactivated)

Saved on

compared with

New Version 14

changes.mady.by.user Sireesha Dugginapeddi [Appfire] (Inactive) (Deactivated)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


Div
idProductTOC

On this page

Table of Contents
maxLevel2
excludeOn this page
typeflat
separator |

Description

Display values from SQL statements or scripts (or both) on Confluence pages. Statements can range from data manipulation language (DML), data definition language (DDL), data control language (DCL), and transaction control language (TCL) statements.

Usage Parameters

Macro Editor LabelDefaultDescriptionParameter
Data source name
Specifies the data source name. It represents an application server defined data source or data source profile defined by your administrator. This is a mandatory field.dataSource
Output formatHTML

Determines how the output is formatted:

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

For more information on Common SQL parameters, refer to Working with SQL parameters - 10.x.

Example

children

Explore SQL Parameters

The SQL macro has dozens of built-in parameters that you can explore and apply. 

...