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 ?

■ row_count count

Count items in query stdout

■ has_rows compare

Check if row count is greater than 0

■ notify ?

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

Settings 7 configurable

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

source setting =

channels setting = in_app

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