| Div | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||
On this page
|
After you have installed the add-on using UPM
- Advanced configuration options are available from the Configure link in add-on administration. Normally, the defaults should be fine.
- At least one data source needs to be configured before you can use the SQL Macro or SQL-query Macro.
Data Sources
...
Security
...
Configure SQL for Confluence
After upgrading or installing SQL for Confluence, navigate to the Global Configuration screen by:
- Logging in as a user with the System Administrator Global Permission.
- Selecting Add-ons from the Administration menu (cog icon:
) at the top right of your screen. Then scroll down to Bob Swift Configuration on the left-hand nav bar and choose SQL Configuration (see: 
)
Global Configuration
This configuration page contains global settings that will control the behavior of Data Sources and Data Source Profiles. Once saved, settings provided on this page are applicable to Data Sources and Data Source Profiles configured sitewide.
Table: configuration options explained
| Option | Default | Description | ||
|---|---|---|---|---|
| Limit rows processed | No limit | The maximum number of rows that will be processed and displayed by SQL macros. This prevents queries that result in a large number of rows from using excessive resources. Individual queries can use the limit parameter to override this value. The following options are available for selection:
| ||
| Limit query time | No limit | The number of seconds that a query can take before we force a timeout. This prevents queries that take too long from impacting other users. Individual queries can use the queryTimeout parameter to override this value.
| ||
| Transaction isolation level | READ_COMMITTED | Default level used if macro parameter does not specify a specific level. The following options are available for selection:
| ||
| Disable anti-XSS mode | OFF | Anti-XSS mode reduces exposure to XSS exploits related to SQL add-on macros. By default, the app respects Confluence's global Anti-XSS setting. This configuration allows an administrator to globally turn off anti-XSS mode only for the SQL Macro of this app. An alternative is to enable groups or individuals to use the disableAntiXss parameter to control this on an individual Macro basis. This may be necessary for queries wanting to produce HTML constructs.
| ||
| Send statistics | ON | As part of building awesome apps, we sometimes need to gather some basic usage data to continually improve. No private user data is sent. For more details on what data is being sent, please refer to this page. |
Next Step: Understanding Data Sources
With global settings now in place, the next step is to bring you up to speed on Data Sources and Data Source Profiles.
