...
The SQL File macro has parameters and behavior similar to the SQL macro. There are two primary reasons for using this macro:
- Security - it can be secured independently of the SQL and SQL attachment macros. If you are an administrator:
- You can control the queries accessible to the general users who are authorized using the Macro Security for Confluence app.
- If you are not using Macro Security for Confluence app, you can disable the SQL and SQL Query macros while allowing access to the SQL File macro. (As it allows users to query only a fixed set of statements.)
- Simplified File Access — the modified parameter makes it easier to specify and read SQL from files.
For more information on:
- Common SQL parameters, refer to Common SQL parameters - 10.x
- Common table parameters, refer to Common Table Parameters - 10.x
Example: Use SQL Macro with Markup