...
...
Scenario
| Div |
|---|
|
 Estimated Time: 4 min
|
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 file located within the /scripts (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:
...
| Code Block |
|---|
|
SELECT title as "Title", author as "Author", price as "Retail Price" FROM books WHERE price < 30 ORDER BY title; |
Steps
The following steps will demonstrate how to use Markup to insert the SQL-file 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 |
|---|
|
 Image RemovedUsing SQL-file with Markup and file on Server | Create Confluence pageCreate 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.
| |
|  Image RemovedUsing SQL-file with Markup and file on Server | Insert the SQL-file Macro using the Insert Markup MenuEdit 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.
| How to insert Markup from the menu 
|
|
...