Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Div
idProductTOC

On this page

Table of Contents
maxLevel1
excludeOn this page
typeflat
separator |

Description

This macro has similar parameters as the the SQL Macro and  and behaves similarly in most cases. There are 2 two primary reasons for using sql-file:

  1. Security - it can be secured separately from the other SQL macros. 
    1. Using CMSP, more general users can be authorized to use this macro since the administrator controls what queries can be accessed.
    2. 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. 
  2. Simplified file access parameter.

...

ParameterRequiredDefaultMacro Browser LabelDescription

file

  • may be restricted
(tick)
File

File path in the configured Confluence server home directory under the script directory.


Include Page
Common SQL parameters - 8.x
Common SQL parameters - 8.x

Examples

No Format
 {sql-file:dataSource=testDS|file=authorized.sql}

...