Ask Your Question

Revision history [back]

The event you should look for is jdbc-query-success, since the query is successful, there's just no data. This event has a rows value that will be zero if the query returned no rows. You can use a Stream Selector or precondition to filter on ${(record:eventType() == 'jdbc-query-success') && (record:value('/rows') == 0)} so you get the email at whenever the query is returning zero rows.