Div |
---|
|
On this page Table of Contents |
---|
maxLevel | 2 |
---|
exclude | On this page |
---|
type | flat |
---|
separator | | |
---|
|
|
...
Parameter | Required | Default | Macro Browser Label | Description |
---|
Data Source (may be restricted) | ![(tick)](/wiki/s/-1810206410/6452/e9334c8677351eb078d9b6505371617879ebf234/_/images/icons/emoticons/check.png) |
| Data Source Name | Specify the Data Source name. It represents an application server defined Data Source or Data Source Profile defined by your administrator. |
file (may be restricted) | ![(tick)](/wiki/s/-1810206410/6452/e9334c8677351eb078d9b6505371617879ebf234/_/images/icons/emoticons/check.png) |
| File | File path in the configured Confluence server home directory under the script directory. |
Output |
|
| Output format | Determines how the output is formatted: - HTML — Generates HTML from the result set data. Data is HTML encoded unless encoding has been disabled.
- 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.
- XHTML (Pro Edition) — Generates and renders XHTML from result set data. Data is HTML encoded unless encoding has been disabled (disableAntiXss).
- 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.
|
For more information on Common SQL parameters, refer to Working with SQL parameters - 9.x.
Examples
Child pages (Children Display) |
---|
...
The SQL Macro has dozens of built in parameters that you can explore and apply.
Image Modified