What does the 'Run Condition' field do in an assistant?

The Run Condition field specifies a SQL-like query that determines when the assistant triggers. It runs every minute (as set in 'Minute'). If the query returns 1, the notification is sent—for example, using 'SELECT 1' makes it run continuously.