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.
Unable to render {include} The included page could not be found.
Examples
{sql-file:dataSource=testDS|file=authorized.sql}