Notification Tech Info

From MiOS
Revision as of 15:31, 15 September 2008 by Micasaverde (Talk | contribs)

Jump to: navigation, search

The following query gets the list of outstanding notifications from the cmh_hosted database:

select * FROM Notification_User LEFT JOIN Notification_Attempt ON FK_Notification_Attempt=PK_Notification_Attempt JOIN Notification ON FK_Notification=PK_Notification WHERE PK_Notification_Attempt IS NULL OR (Final=0 And Result>1);

NotificationType is a single character: E, S, V for Email/SMS/Voice. Destination is the corresponding destination (email/phone number).

Personal tools