From: Andrew V. <av...@us...> - 2005-03-29 21:16:17
|
Update of /cvsroot/mailmanager/mailmanager/sql In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv19019 Modified Files: Tag: db-backend userPriority.zsql userStatus.zsql Log Message: Whoops! Missed off a few of my schema declarations. Index: userPriority.zsql =================================================================== RCS file: /cvsroot/mailmanager/mailmanager/sql/Attic/userPriority.zsql,v retrieving revision 1.1.2.2 retrieving revision 1.1.2.3 diff -u -d -r1.1.2.2 -r1.1.2.3 --- userPriority.zsql 29 Mar 2005 14:36:07 -0000 1.1.2.2 +++ userPriority.zsql 29 Mar 2005 21:15:54 -0000 1.1.2.3 @@ -4,15 +4,15 @@ arguments: </dtml-comment> SELECT username, - (SELECT COUNT(1) FROM mm_ticket + (SELECT COUNT(1) FROM <dtml-var schema>mm_ticket WHERE priority=1 AND mm_ticket.assigned=username) AS junk, - (SELECT COUNT(1) FROM mm_ticket + (SELECT COUNT(1) FROM <dtml-var schema>mm_ticket WHERE priority=2 AND mm_ticket.assigned=username) AS low, - (SELECT COUNT(1) FROM mm_ticket + (SELECT COUNT(1) FROM <dtml-var schema>mm_ticket WHERE priority=3 AND mm_ticket.assigned=username) AS normal, - (SELECT COUNT(1) FROM mm_ticket + (SELECT COUNT(1) FROM <dtml-var schema>mm_ticket WHERE priority=4 AND mm_ticket.assigned=username) AS high, - (SELECT COUNT(1) FROM mm_ticket + (SELECT COUNT(1) FROM <dtml-var schema>mm_ticket WHERE priority=5 AND mm_ticket.assigned=username) AS critical FROM <dtml-var schema>mm_user, <dtml-var schema>mm_ticket WHERE mm_ticket.assigned=mm_user.username Index: userStatus.zsql =================================================================== RCS file: /cvsroot/mailmanager/mailmanager/sql/Attic/userStatus.zsql,v retrieving revision 1.1.2.2 retrieving revision 1.1.2.3 diff -u -d -r1.1.2.2 -r1.1.2.3 --- userStatus.zsql 29 Mar 2005 14:36:07 -0000 1.1.2.2 +++ userStatus.zsql 29 Mar 2005 21:15:54 -0000 1.1.2.3 @@ -4,15 +4,15 @@ arguments: </dtml-comment> SELECT username, - (SELECT COUNT(1) FROM mm_ticket + (SELECT COUNT(1) FROM <dtml-var schema>mm_ticket WHERE status='open' AND mm_ticket.assigned=username) AS open, - (SELECT COUNT(1) FROM mm_ticket + (SELECT COUNT(1) FROM <dtml-var schema>mm_ticket WHERE status='hold' AND mm_ticket.assigned=username) AS hold, - (SELECT COUNT(1) FROM mm_ticket + (SELECT COUNT(1) FROM <dtml-var schema>mm_ticket WHERE status='closed' AND mm_ticket.assigned=username) AS closed, - (SELECT COUNT(1) FROM mm_ticket + (SELECT COUNT(1) FROM <dtml-var schema>mm_ticket WHERE status='spam' AND mm_ticket.assigned=username) AS spam, - (SELECT COUNT(1) FROM mm_ticket + (SELECT COUNT(1) FROM <dtml-var schema>mm_ticket WHERE unread='true' AND mm_ticket.assigned=username) AS new, (SELECT 1) AS overdue FROM <dtml-var schema>mm_user, <dtml-var schema>mm_ticket |