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.