...

...

Scenario

In this scenario, we will let's insert the SQL Macro macro on a Confluence page by inserting Markup from the menu. Our SQL Macro will reference The SQL macro uses the SQL statement loaded into the body of the Macromacro.

Background

Our This scenario will use a Data Source Profile called "BookWarehouse" to uses a data source profile, BookWarehouse, to query a database table called ", PUBLISHERS". The table contains the following columns and rows:

SQL > select * from publishers;
+----+------+-------------------+-----------------+---------+
| id | rank | parent_company    | company_name    | revenue |
+----+------+-------------------+-----------------+---------+
| 10 | 1    | Pearson           | Pearson         | 5000.00 |
| 11 | 2    | Reed              | RELXGroup       | 4900.00 |
| 12 | 3    | WoodbridgeCompany | ThompsonReuters | 4700.00 |
| 13 | 4    | BertelsmannAG-NV  | Bertelsmann     | 4500.00 |
| 14 | 5    | WoltersKluwer     | WoltersKluwer   | 4100.00 |
+----+------+-------------------+-----------------+---------+

...

The sample query against the PUBLISHERS table looks like:

 SELECT rank as "Worldwide Ranking", company_name as "Company", format(revenue,0) as "M Revenue" FROM publishers ORDER BY rank asc;

Steps

The following steps will demonstrate demonstrates how to use Markup to insert the SQL Macro macro on a Confluence page.:

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 to add the SQL Macro macro needed to list out top publishers. Create a page named Top Publishers Worldwide in a space accessible to the desired audience. Click Save to save the new page. Insert the SQL Macro macro using the Insert Markup Menu Edit the Top Publishers Worldwide page and: Select Insert Markup from the top menu. Type the follwing following into the editor window. : (Note the dataSource name  referenced. data source name referenced) Code Block  {sql:dataSource=BookWarehouse} SELECT rank as "Worldwide Ranking", company_name as "Company", format(revenue,0) as "M Revenue" FROM publishers ORDER BY rank asc; {sql} Click Insert to insert your Markup within the page. Click Save to save your page and view your results. Alternative: Insert the SQL Macro macro using Markup on page Edit the Classic Books page and: On the page, begin typing "{" (open parenthesis) and then type "sql". Select "sql" from SQL from the available list of Macrosmacros. The Macro macro editor dialog will appearappears. Select "BookWarehouse" as the Data source name. Type your SQL statement into the body of the Macro macro block. 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 Alternate method:

Explore Tutorials

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