PRINT Statement use in the SQL Macro
SQL-1057
Exclude the column type and special chars '(' and ')' on columns search
SQL-1056
As a SQL macro user, I should be able to update tables in addition to displaying them from the Confluence page
SQL-992
Changes made in server.xml for a global DS not reflecting in the Profiles section of Global config
SQL-980
Allow using Template variables inside SQL macro
SQL-957
Option to set the data source profile to be used by a specific user groups/spaces
SQL-942
Encrypt field DBPASSWORD in database
SQL-940
Allow rendering of hyperlink by querying database.
SQL-937
SQL assist/ suggest and auto complete as the user types ahead
SQL-933
Ability to provide suggestions to optimize SQL statements in the macro editor
SQL-930
Ability to validate the SQL statement in the macro editor
SQL-925
Format of the table is lost and the whole table is downloaded with 'Allow download and export' option when SQL for confluence is nested within table filter macro.
SQL-924
As a German language user, I should be able to view all the UI text elements in macro editor, to use the SQL macros
SQL-923
Enable SQL statements to be parameterized
SQL-919
Embed other macros into SQL statements
SQL-918
Caching query results toggle for customers having Cache for Confluence app
SQL-917
Caching query results
SQL-916
Interactive/ rich charting capabilities for the output
SQL-915
Export/ download results as CSV: Is it possible to change the comma used, using for example ; instead of , ?
SQL-914
Provide search capability to find the macro parameters in the new editor
SQL-883
Provide support to other Databases (Athena dB)
SQL-880
Include default values for labels/ text in Transaction level, Max no. of rows, Max time in secs parameters
SQL-875
“use database column labels” parameter does not seem to work with postgres, oracle at least, not sure if its a limitation on the jdbc driver. We may need to look more into it, whether it worked earlier.
SQL-841
Switch between SQL editor and parameters tabs while working with parameter markers (p1, p2 and so on)
SQL-838
Ability to restrict admins access to SQL data source usernames and passwords
SQL-816
SQL Query macro does not render in mobile application
SQL-811
Download large lists by chunking the data
SQL-684
Securing sensitive data like ip address, username, password and dBurl
SQL-683
Please update doc inline with changes done in SQL-621
SQL-678
The order of the tabs on the config page seems opposite of what I would expect. The profile list is most important and should be first.
SQL-672
Add Profile button is the most important button on the form. See guidelines but show that button in blue to direct users. And what's with the +?
SQL-671
Expand text for more information and show less text initially (like in the Add Profile dialog)
SQL-670
"Failed - Network Error" message when trying to download a table
SQL-644
Delegating the Data source configuration and creation to a certain group of users
SQL-641
Bob's "New Customer" feedback on SQL Experience
SQL-615
Support multiple jars for teradata database
SQL-526
Add ability to export configuration settings
SQL-519
Table customisations do not work on Scroll-viewport theme
SQL-512
Formatting and styling support for vertical row orientation
SQL-483
Support for sybase
SQL-479
SQL Macro executing on page render
SQL-440
Security level "Only-in-User-Macros"
SQL-426
Use a Confluence table as a data source
SQL-413
Freeze first row of table
SQL-408
Support integration with the Page Properties and Page Properties Report macros
SQL-385
Restrict UI data source picker values by group
SQL-368
Option to provide a custom error message in place of SQL error
SQL-365
Support Oracle cursor variable produced by stored procedure
SQL-345
Styling for the last row of a table
SQL-341
Is it possible to get pagination on sql macro
SQL-305
issue 1 of 77

PRINT Statement use in the SQL Macro

Description

Hi Team,

Usage of PRINT Statement does not print the output on the Confluence Page when used with SQL Macro.

Use case -

When executing a PRINT Statement in SQL clients, the query runs successfully with OK prompt but the output does not print on the query console.

Screenshot shared below:

In SQL Macro, when applied to the same PRINT query, we don't see any preview of the output or error message. The Confluence page with SQL Macro is left blank.

SQL Macro screenshot below:

Environment

None

Status

Assignee

Sunita Patro

Reporter

Jagruti Waghulde

Labels

None

Support Entitlement

None

Priority

Major
Configure