Use “SQLite query result watch” in Recued. It provides a scheduled, read-only watch for one local SQLite query. Changes remain behind Recued's approval controls.

How it works 7 steps

Inspect the data fetches, transforms, gates, and output this recipe runs.

Process (7 steps)

◆ query recued-core.sqlite3.db.query_readonly

Query readonly db on sqlite3

■ row_count count

Count items in query stdout

■ has_rows compare

Check if row count is greater than 0

◆ notify core.notification.send

Send notification

skip: step.has_rows not_equal true

■ rows slice

Take a subset of

■ table to_table

Format results as a data table

■ card to_summary

Format results as a summary card

▼

Output

summary card

table table

Settings 7 configurable

Configurable at install. Defaults shown — change them anytime in Recued.

source setting = [object Object]

channels setting = [object Object]

end hour setting = 18

max rows setting = 25

weekdays setting = 1,2,3,4,5

sql query setting = SELECT name AS label, type AS detail, tbl_name AS result FROM sqlite_schema WHERE 0

start hour setting = 8