/
SQL - 9.x

 



SQL - 9.x

Owned by Randall Ward
Last updated: Feb 24, 2020 by Smita Nair

On this page

Description

Display values from SQL statements on Confluence pages. Statements can range from read-only SELECT statements to Data Manipulation Language (DML) statements such as INSERT, UPDATE, and DELETE. 

Usage Parameters

NameRequiredDefault ValueMacro Browser LabelDescription
Data source
(may be restricted)		(tick)
Data Source NameSpecify the data source name. It represents an application server defined data source or data source profile defined by your administrator.
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 contains unintended wiki markup characters, set the escape parameter as 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

Explore SQL parameters

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


Log a request with our support team.

Confluence®, Jira®, Atlassian Bamboo®, Bitbucket®, Fisheye®, and Atlassian Crucible® are registered trademarks of Atlassian®
Copyright © 2005 - 2024 Appfire | All rights reserved. Appfire™, the 'Apps for makers™' slogan and Bob Swift Atlassian Apps™ are all trademarks of Appfire Technologies, LLC.