Notification Tech Info
From MiOS
(Difference between revisions)
Micasaverde (Talk | contribs) (New page: 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_N...) |
Micasaverde (Talk | contribs) |
||
| Line 5: | Line 5: | ||
JOIN Notification ON FK_Notification=PK_Notification | JOIN Notification ON FK_Notification=PK_Notification | ||
WHERE PK_Notification_Attempt IS NULL OR (Final=0 And Result>1); | 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). | ||
Revision as of 15:31, 15 September 2008
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).
