Description
This macro has similar parameters as the SQL Macro and behaves similarly in most cases. There are 2 primary reasons for using sql-file:
- Security - it can be secured separately from the other SQL macros.
- Using Macro Security for Confluence, more general users can be authorized to use this macro since the administrator controls what queries can be accessed.
- When not using Macro Security for Confluence, the administrator can disable the sql and sql-query macros and still allow the sql-file macro since it has a fixed set of queries that can be run.
- Simplified file access parameter.
Parameter | Required | Default | Macro Browser Label | Description |
---|---|---|---|---|
file
| File | File path in the configured Confluence server home directory under the script directory. |
Unable to render {include} The included page could not be found.
Examples
{sql-file:dataSource=testDS|file=authorized.sql}