Atlassian uses cookies to improve your browsing experience, perform analytics and research, and conduct advertising. Accept all cookies to indicate that you agree to our use of cookies on your device. Atlassian cookies and tracking notice, (opens new window)
Teams
, (opens new window)
SQL for Confluence
Results will update as you type.
  • SQL for Confluence
  • _InclusionsLibrary
  • _Archive
    You‘re viewing this with anonymous access, so some content might be blocked.
    /
    How to improve the display of SQL source

    How to improve the display of SQL source

    This content is archived.
    Learn more
    Jan 26, 2023

    Summary

    The Show SQL option in the SQL Macro and SQL Query Macro allows the SQL source to be displayed after the result data. This is helpful for problem determination and it also provides a way for users to copy the SQL for use in a slightly different query. With release 6.4, there are new options for controlling how the code is displayed.

    The SQL is normally displayed with the default code macro. The new Options for showing SQL code (showSqlOptions) parameter allows you to enter a list of macro parameters to be applied to the code macro. Moreover, if you have the /wiki/spaces/CODE/pages/67666007 macro installed, you can use those parameters as well. 

    Example

    This uses the more advanced code-pro parameters that shows the source in a collapsed section.

    After clicking SQL section:

    , multiple selections available,

    Need support? Create a request with our support team.

    Copyright © 2005 - 2025 Appfire | All rights reserved.

    {"serverDuration": 18, "requestCorrelationId": "5bd4f9279a6c403085d6758636e800bd"}