Scenario

In this scenario, we will insert the SQL-file Macro on a Confluence page by inserting Markup from the menu. Our SQL-file Macro will reference a file containing SQL located within the /script (default) directory of your Confluence server.

Background

Our scenario will use a Data Source Profile called "BookWarehouse" to query a database table called "BOOKS". The table contains the following columns and rows:

...

Table plus
border 0 heading 0 multiple false enableHeadingAttributes false columnAttributes style="border:0;width=5%;",style="border:0;width=65%;",style="border:0;width=30%;max-width=30% !important;" id steps_table enableSorting false enableHighlighting false
Create Confluence page Create a Confluence page that will eventually contain the SQL-file Macro needed to list out your books. Create a page named Classic Books in a space accessible to the desired audience. Click Save to save the new page. Insert the SQL-file Macro using the Insert Markup Menu Edit the Classic Books page and: Select Insert Markup from the top menu. Type the follwing into the editor window. Note the dataSource name and file name referenced.  Code Block  {sql-file:dataSource=BookWarehouse|file=books.sql} Click Insert to insert your Markup within the page. Click Save to save your page and view your results. Alternative: Insert the SQL-file Macro using Markup on page Edit the Classic Books page and: On the page, begin typing "{" (open parenthesis) and then type "sql-" Select "sql-file" from the available list of Macros. The Macro editor dialog will appear. Type "books.sql" into the required "File" field. Select "BookWarehouse" as the Data source name Click Insert to insert your Markup within the page. Click Save to save your page and view your results. How to insert Markup from the menu

Explore Tutorials

We've prepared a number of tutorials which demonstrate how to use our SQL Macros with the native Chart Macro.

Image Added