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:

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

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