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.
The SQL query to be executed. See below for an example.
The SQLite Connection to use. See the Connecting to an SQLite Database article if you require more information on how to create/manage connections.
See Common Task Settings.
A sample query is shown below, which will return the total
Balance across all rows in the
SELECT SUM(Balance) FROM Accounts
Back | Edit on Github