Query Preview

Overview

Query Preview allows PocketQuery administrators to test and validate queries before they are published on a Confluence page. This feature ensures that queries return the expected results, reducing errors and improving efficiency.

How to Use Query Preview

1. Test the Datasource Connection

Go to PocketQuery Administration via the Apps menu in Confluence.
Open the edit form of a Query you want to test.
Below the Datasource selection, click the Test Connection link to verify that your Datasource is connected properly:
Result: a message will indicate whether the connection was successful.

2. Preview your Query (with Converter)

In the Query edit form, scroll down to the Query Preview section.
Click the Run Query Preview button.
- If your Query uses parameters, make sure to fill them in first.
If successful, the preview will display the results of your Query, including any applied Converter:

3. Preview your Template

Switch to the Template Preview tab.
Click the Run Template Preview button.
- If your Query uses parameters, make sure to fill them in first.
The preview will display how your Query results appear when combined with the selected Template:

Template Preview in PocketQuery Interface

Actions in the Preview

Once your preview is displayed, you can perform the following actions:

Button	Action
	Copy your table / JSON to the clipboard
	Display the preview in full-screen mode
	Switch between Table and JSON view