⚽ Bounced Recommendation Emails

If a student adds a recommender to their application, and the email bounces, it can be tricky to find those bounces and alert the student.

This suitcase contains a query that should find the recommenders who have a bounced email: 0fb6dbff-72f1-4348-9f4b-15376245ccb2:rwf

The query is on the Application Reference base:

The key is an independent formula subquery filter:

Formula:

EXISTS (
        SELECT 1
        FROM [message] AS msg
        WHERE msg.[xml].exist(
              '//*[contains(string(.), concat(sql:column("ar__JID_.[key]"), sql:column("ar__JID_.[pin]")))]'
        ) = 1
  AND msg.[status] = 'bounce'
  )

Please try this out in your instance and report back if something isn't right! support@reworkflow.com