Overview

The SQL Condition monitor is very closely related to the No-Code Condition monitor. It allows to write a condition as a SQL query. It should be used when the flexibility of the No-Code Condition monitor is not enough.

How to use

1. Datasets & Joins

See here

2. SQL query

The SQL query is the condition. It should return a boolean per row. A true value means that the condition fails.

⚠️

To insert fields inside this query, fields must use the special formatting: datasetId:fieldName.

In the UI, you can use the autocompletion to insert fields with this format. To trigger it, simply start writing the name of your table and the list of fields of your table should be listed.

⚠️

Querying others tables is not allowed inside the SQL query. You should only tables that are selected in the join clause defined before.

Examples:

datasetId:email IS NOT NULL
datasetId1:field1 + datasetId2:field2 < 10 

3. Other settings

See here