Div |
---|
|
On this page Table of Contents |
---|
maxLevel | 1 |
---|
exclude | On this page |
---|
type | flat |
---|
separator | | |
---|
|
|
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 CMSP, more general users can be authorized to use this macro since the administrator controls what queries can be accessed.
- When not using CMSP, 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.
Parameters
Parameter | Required | Default | Macro Browser Label | Description |
---|
file | ![(tick)](/wiki/s/19829951/6452/74bb90925e58a0b8983b8579f502578d16fe7cf3/_/images/icons/emoticons/check.png) | | File | File path in the configured Confluence server home directory under the script directory. |
...
Examples
No Format |
---|
{sql-file:dataSource=testDS|file=authorized.sql} |
Image Removed
...
Include Page |
---|
| SQL-file Macro - 8.x |
---|
| SQL-file Macro - 8.x |
---|
|