Versions Compared

Version Old Version 6 New Version 7
Changes made by

Nisha Shantilal

Nisha Shantilal

Saved on

Key

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

...

  • The administrator sets the default value on the SQL for Confluence configuration page. To set the 'Maximum number of seconds for query to run' in Global Configuration, refer to Global Configuration.

    SQL_Global_Config.jpg

Administrators can enable the Restrict overriding global configuration limits flag to prevent overriding the Limit query time parameter and enforce the default value set on the Global configuration page. For more information, refer to Get Started - Configuration - 11.x.

GlobalConfig_RestrictOverriding.jpgImage Added

  • An administrator can override the global queryTimeout setting for specific data source profiles in Global Configuration. The global setting takes effect if this is not overridden. For more information, refer to Data Source Profiles - Limit query time.

    Datasource_Limitquery.jpg

  • Users can change the default queryTimeout parameter value for the SQL and SQL-Query macros. Selecting a value from the list for Maximum number of seconds for query to run overrides the default.

    SQL Query macro.jpg
Info

Overriding the queryTimeoutparameter

  • The default value is set by the administrator via the Global configuration page or Profile configuration page.

  • Selecting a value in the sql and sql-query macros overrides the default. The order of overriding the default setting is Macro level parameter > Profile configuration > Global configuration.

  • Your database and JDBC driver must support the selected value to use this parameter.

  • If the Restrict overriding global configuration limits flag is enabled on the Global configuration page, then the default value set for the Limit query time parameter on the Global configuration page is considered and cannot be overridden.

  • Administrators can limit (or control) who can use this parameter through the use of our Macro Security for Confluence app.

...