.png?version=1&modificationDate=1662627367996&cacheVersion=1&api=v2&width=226&height=72)
Improve the display of SQL source - 10.x
- Saumya Sunder (Inactive) (Deactivated)
- Nisha Shantilal
- Smita Nair
- Sireesha Dugginapeddi [Appfire] (Inactive) (Deactivated)
Summary
The Show SQL option on the SQL and SQL Query macros allow the SQL source to be displayed after the result data. This is helpful for problem determination. 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 that will be applied to the Code macro. Moreover, if you have the Code Pro macro installed, you can use those parameters as well.
Example
This uses the more advanced Code Pro parameters that show the source in a collapsed section.
Assuming you have selected the required data, provide the following inputs:
| Display settings > Advanced formatting > Show SQL | On |
|---|---|
| Display settings > Advanced formatting > Options for showing SQL code | collapseType = expand, collapse = true |
| Column settings > Numbering & totaling > Auto total numeric columns | On |
After expanding SQL preview:
Log a request with our support team.
Confluence®, Jira®, Atlassian Bamboo®, Bitbucket®, Fisheye®, and Atlassian Crucible® are registered trademarks of Atlassian®
Copyright © 2005 - 2024 Appfire | All rights reserved. Appfire™, the 'Apps for makers™' slogan and Bob Swift Atlassian Apps™ are all trademarks of Appfire Technologies, LLC.