Skip to main content
Skip table of contents

Prerequisites for the Templating Tutorial

This tutorial shows a few templating examples for the sample WorldDB provided by the official MySQL docs. We will use a simple query with two named parameters:

CODE
SELECT Name, Population
FROM Country
WHERE Population > :min AND  Population < :max

If you want to follow along download the WorldDB and insert it into a database. Then, set up a connection to it as JDBC datasource in the PocketQuery administration and add our sample statement as a query:

When using this query you will be able to display names and populations of countries. You can specify a population range you are interested in when adding the PocketQuery add-on to an issue. Simply set the parameters 'min' and 'max' to your liking.

Continue with The Default Template

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.