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...) |
Revision as of 15:29, 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);
