Execute Scalar Query

This task will execute a scalar query (a query which returns a single result) against an SQLite database. This is useful for fetching data to be used in Dashboards.

Settings

Query

Required
The SQL query to be executed. See below for an example.

Connection

Required
The SQLite Connection to use. See the Connecting to an SQLite Database article if you require more information on how to create/manage connections.

Zynk Settings

See Common Task Settings.

Examples

A sample query is shown below, which will return the total Balance across all rows in the Accounts table.

SELECT SUM(Balance) FROM Accounts