Spaces
Apps
Templates
Create
One Appfire Support Knowledge Base
All content
Calendars
Space settings
Content
Results will update as you type.
Show more above
BI and Reporting Apps
Rich Filters for Jira Dashboards App
Rich Filters Support
Arsenale Dataplane
Power Dashboard Reports and Gadgets Knowledge Base
Dashboard Hub KB - Ronin Pixels
Charts & Graphs for Bitbucket
Tableau Connector Pro for Jira
Power BI Connector Pro for Jira
Database Exporter for Jira Cloud
Reports and Timesheets for Jira
Excel for Confluence (XL)
SQL for Confluence (SQL)
•
How to find all pages that use SQL for Confluence (Pro Edition) macros via database
•
Troubleshooting the user permissions issue in the SQL Query Macro using the SQL for Confluence App
•
SQL for Confluence app gets disabled when upgraded to v10.4.1
•
How to find the memory consumed by database tables using SQL for Confluence app
•
Add Profile for Microsoft SQL Server using SQL for Confluence
•
How to convert text to hyperlinks using SQL queries with SQL for Confluence
•
How to get usage information of an app being used in space templates
•
How to retrieve data with single quotes from Oracle database fields
•
How to display links in SQL results using SQL for Confluence
•
How to resolve an Access denied error - 10.x
•
How to add queries within queries
•
How to resolve an Authentication failed error - 10.x
•
How to avoid format errors when using output=wiki
•
How to resolve broken database connections - 10.x
•
How to resolve a Class not found error - 10.x
•
How to combine queries from multiple databases
•
How to update database columns and display them in a page using Run macro with SQL macro
•
Configure application server based datasources - 10.x
•
Configure data source profiles 10.x
•
How to resolve an Invalid syntax server.xml error
•
How to resolve a Could not create connection to database server error - 10.x
•
Create a chart with SQL - 10.x
•
How to resolve a Data source name not found error - 10.x
•
How to resolve a Database server not found error - 10.x
•
Datasource problem determination - 10.x
•
Example profile configurations
•
Error while retrieving the data using SQL for Confluence
•
How to resolve a Generic SQL exception - 10.x
•
How to find pages that uses a specific data source profile in different SQL macros
•
How to get favorites list of Confluence users using Sql for Confluence
•
How to configure data source profiles for various databases with examples
•
How to do data source problem determination
•
How to handle the "No suitable driver found" error when connecting to an MS-SQL database
•
How to hyperlink the SQL macro results
•
How to implement role based security for SQL queries - 8.x
•
How to improve the display of SQL source - 8.x
•
How to show all table rows using a nested query with SQL for Confluence
•
How to implement role based security for SQL queries - 10.x
•
How to improve the display of SQL source - 10.x
•
How to index SQL data
•
How to use SQL data with inline macros
•
How to resolve a Listener refused connection error - 10.x
•
How to log SQL activity
•
Pro tips
•
How to publish SQL queries on Atlassian Cloud
•
How to run SQL queries securely without page edit restrictions
•
Sample Queries - Confluence Labels
•
How to resolve the Unable to load database driver error
•
How to use Confluence metadata in SQL queries
•
How to use HTML in queries
•
How to use SQL case statement to improve the visual appeal
•
How to use SQL macros securely
•
Using the SQL macro with Markup - 9.x and earlier
•
How to resolve an Oracle validation query throwing exception - 10.x
•
UI caching problem with SQL for Confluence
•
How to create a temporary MySQL table using the SQL for Confluence (Pro edition) app
•
Using SQL File with Markup - 9.x and earlier
•
How to use MySQL functions in SQL macro
•
How to get usage information about the SQL for Confluence app
•
How to create a database profile with read-only access using the SQL for Confluence app
•
How to set SSL connection for SQL server with SQL for Confluence (Pro Edition)
•
Connect SQL macro to MS SQL database using Windows authentication
•
Unable to see table views in SQL macro
•
How to use the Expand array option in SQL for Confluence to view values with line break
•
Use SQL Macro with Markup - 10.x
•
Use SQL File Macro with Markup - 10.x
•
Create a Bar chart using SQL macro
•
Create a Pie chart using the SQL macro
•
Create an xyArea chart using the SQL macro
•
Create an xyLine chart using the SQL macro
•
How to resolve a network error due to invalid database port - 10.x
•
How to resolve isValid exceptions - 10.x
•
How to resolve a Cannot load JDBC driver error - 10.x
•
How to resolve a Permission denied error - 10.x
•
How to resolve a Validation query exception - 10.x
•
How to implement role based security for Postgre SQL database - 10.x
•
How to limit active database connections
•
How to use SQL macro in a Confluence user macro
•
How to use macros parameter within nested SQL queries
•
How to resolve the Unable to connect to database error
•
How to create a chart with SQL - 8.x
•
How to implement role based security for Postgre SQL database - 8.x
•
User Macro with sql-query failed after Confluence upgrade to 7.7 version
•
SSL connection to Oracle DB setup issues in SQL for Confluence
•
Unable to load database driver: com.xxx.jdbc.Driver
•
How to Create a Chart From SQL Data
•
How to Automatically Create a Formatted Table From SQL Data
Run Self-Service Reports for Confluence (RUN)
Advanced Tables for Confluence (TBL)
Graphviz Diagrams for Confluence (GVIZ)
Macro Security for Confluence (CMSP)
•
The Markdown for Bitbucket macro (Cloud) encounters a 500 error when the Markdown Extensions for Confluence App is used.
•
How to retrieve debug logs for Appfire's Jira apps
Publishing
Agile
Document Management
ITSM
Developer Tools
Workflow & Automation
Integrations KB's
Show more below
Blogs
Apps
Comala Publishing
Comala Document Management
Document Report
Miro Gallery
Gliffy Diagram
draw.io Diagrams
Links
You‘re viewing this with anonymous access, so some content might be blocked.
Close
One Appfire Support Knowledge Base
/
/
SQL for Confluence (SQL)
/
Create a Pie chart using the SQL macro
Create a Pie chart using the SQL macro
Smita Nair
Owned by
Smita Nair
Last updated:
Feb 25, 2020
Loading data...