Configuring Database Queries

In the db command, you can use saved database queries. The name of the saved query is passed to the command as the query parameter. To create or edit a query, go to the Settings - Management - JDBC Queries section:

To create a new query, click the New Macros button in the top right corner. To edit a query, click on it in the list. Below is an example of a filled configuration for a JDBC query named click_query:

Click the Save button, and the query will be ready to use in the db command.

Command Execution Example

db connection=click query=click_query