Using SQL File with Markup - 9.x and earlier
Scenario
In this scenario, let's insert the SQL File macro on a Confluence page by inserting Markup from the menu. Our SQL File macro references a file containing SQL located within the /script (default) directory of your Confluence server.
Background
Our scenario uses a data source profile, BookWarehouse, to query a database table, BOOKS. The table contains the following columns and rows:
SQL > select * from books; +----+----------------------------+---------------------+-------+ | id | title | author | price | +----+----------------------------+---------------------+-------+ | 1 | The Grapes of Wrath | John Steinbeck | 12.99 | | 2 | Nineteen Eighty-Four | George Orwell | 8.99 | | 3 | The Wind-Up Bird Chronicle | Haruki Murakami | 7.99 | | 4 | Don Quixote | Miguel De Cervantes | 29.99 | | 5 | Pilgrims Progress | John Bunyan | 17.99 | | 6 | Robinson Crusoe | Daniel Defoe | 29.05 | | 7 | Gullivers Travels | Jonathan Swift | 15.98 | | 8 | Tom Jones | Henry Fielding | 13.59 | | 9 | Clarissa | Samuel Richardson | 13.59 | | 10 | Tristram Shandy | Laurence Sterne | 7.59 | +----+----------------------------+---------------------+-------+
For information about data source profiles, refer to:
- Data source profiles for 9.x versions
- Data source profiles for 8.x versions
Our query is stored within a file called books.sql and along with our Confluence administrator to place it within the /script (default) directory on our Confluence server. Our query looks like:
SELECT title as "Title", author as "Author", price as "Retail Price" FROM books WHERE price < 30 ORDER BY title;
Steps
The following steps demonstrates how to use Markup to insert the SQL File macro on a Confluence page:
Explore Tutorials
We've prepared a number of tutorials which demonstrates how to use our SQL macros with the native Chart macro.