From 1fa02d6ffb746480b0cd43b2b0ede6a0704dc7c4 Mon Sep 17 00:00:00 2001 From: Eric Bollengier Date: Sun, 22 Jun 2008 18:49:10 +0000 Subject: [PATCH] ebl Update overview git-svn-id: https://bacula.svn.sourceforge.net/svnroot/bacula/trunk@7218 91ce42f0-d328-0410-95d8-f526ca767f89 --- gui/bweb/lib/Bweb.pm | 5 +++-- 1 file changed, 3 insertions(+), 2 deletions(-) diff --git a/gui/bweb/lib/Bweb.pm b/gui/bweb/lib/Bweb.pm index e99a3f710e..2d9eb7988e 100644 --- a/gui/bweb/lib/Bweb.pm +++ b/gui/bweb/lib/Bweb.pm @@ -3749,8 +3749,8 @@ FROM ( JOIN Client USING (ClientId) $filter JOIN Status USING (JobStatus) WHERE client_group_name IN ($arg->{jclient_groups}) - $limit $filter2 AND JobStatus IN ('T', 'f', 'A', 'e', 'E') + $limit $filter2 GROUP BY Client.Name, date ) AS sub JOIN Status USING (severity) ORDER BY name, date @@ -3784,7 +3784,8 @@ FROM ( JOIN client_group_member USING (ClientId) JOIN client_group USING (client_group_id) $filter3 JOIN Status USING (JobStatus) - WHERE true $filter1 $filter2 + WHERE JobStatus IN ('T', 'f', 'A', 'e', 'E') + $filter1 $filter2 GROUP BY client_group_name, date ) AS sub JOIN Status USING (severity) ORDER BY name, date -- 2.39.5