2 Apr 2003 00:13
CVS: opennms/src/web/src/org/opennms/web/notification NotificationModel.java,1.3,1.4
<cvs-admin <at> lists.opennms.org>
2003-04-01 22:13:55 GMT
2003-04-01 22:13:55 GMT
Update of /cvsroot/opennms/opennms/src/web/src/org/opennms/web/notification
In directory sc8-pr-cvs1:/tmp/cvs-serv25778
Modified Files:
NotificationModel.java
Log Message:
Fixed a possible bug with the number of notifications outstanding.
Index: NotificationModel.java
===================================================================
RCS file: /cvsroot/opennms/opennms/src/web/src/org/opennms/web/notification/NotificationModel.java,v
retrieving revision 1.3
retrieving revision 1.4
diff -u -r1.3 -r1.4
--- NotificationModel.java 8 Jan 2003 19:24:24 -0000 1.3
+++ NotificationModel.java 1 Apr 2003 22:13:53 -0000 1.4
<at> <at> -60,7 +60,7 <at> <at>
private final String OUTSTANDING = "SELECT textmsg, numericmsg, notifyid, pagetime, respondtime,
answeredby, nodeid, interfaceid, serviceid, eventid FROM NOTIFICATIONS WHERE respondTime is NULL";
private final String OUTSTANDING_COUNT = "SELECT COUNT(*) AS TOTAL FROM NOTIFICATIONS WHERE
respondTime is NULL";
private final String USER_OUTSTANDING = "SELECT textmsg, numericmsg, notifyid, pagetime,
respondtime, answeredby, nodeid, interfaceid, serviceid, eventid FROM NOTIFICATIONS WHERE
(respondTime is NULL) AND notifications.notifyid in (SELECT DISTINCT usersnotified.notifyid FROM
usersnotified WHERE usersnotified.userid=?)";
- private final String USER_OUTSTANDING_COUNT = "SELECT COUNT(*) AS TOTAL FROM NOTIFICATIONS WHERE
(respondTime is NULL) AND AND userID LIKE ?";
+ private final String USER_OUTSTANDING_COUNT = "SELECT COUNT(*) AS TOTAL FROM NOTIFICATIONS WHERE
(respondTime is NULL) AND notifications.notifyid in (SELECT DISTINCT usersnotified.notifyid FROM
usersnotified WHERE usersnotified.userid=?)";
(Continue reading)
RSS Feed