.png?version=1&modificationDate=1662627367996&cacheVersion=1&api=v2&width=226&height=72)
This page provides all the relevant information required to customize and use the app in an efficient and optimal manner.
The SQL Query macro displays 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.
Some databases support read-only SQL statements. The SQL Query macro uses this support, if applicable, with such databases.
Read-only support means that the database can optimize for read-only statements. For some databases (PostgreSQL, for instance) the read-only condition is enforced while in others, it is a suggestion for improving performance.
Parameters
The following parameters are available in the macro editor:
| Macro editor tab | Macro editor label | Default value | Description | Macro parameter |
|---|---|---|---|---|
| Main panel | Data source profile | |||
| Select SQL as an attachment | ||||
| SQL statement | ||||
| Settings > Runtime | Transaction isolation level | |||
| Maximum number of rows to retrieve and display | ||||
| Maximum number of seconds for query to run | ||||
| Settings > Rendering | Table ID | |||
| Display data filter | ||||
| Insert auto number column | ||||
| Enable pagination | ||||
| Number of rows to be displayed on one page | ||||
| Show error if there are no rows | ||||
| Text to display when there are no rows | ||||
| Show SQL |
Helpful resources
- Administrator guide to know more about app configuration
- Tutorials to understand app usage
