From c66c04088998b6ff011613e0439be51c5219dad6 Mon Sep 17 00:00:00 2001 From: Eric Bollengier Date: Sun, 26 Sep 2010 23:38:45 +0200 Subject: [PATCH] bweb: don't display general job errors when using client filter --- 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 97a29f2da3..15e2d06229 100644 --- a/gui/bweb/lib/Bweb.pm +++ b/gui/bweb/lib/Bweb.pm @@ -2235,7 +2235,8 @@ sub display_general my ($self, %arg) = @_ ; my ($limit, $label) = $self->get_limit(%arg); - + my $filter = $self->get_client_filter(); + $filter = $filter? " JOIN Client USING (ClientId) $filter " : ''; my $query = " SELECT (SELECT count(Pool.PoolId) FROM Pool) AS nb_pool, @@ -2244,7 +2245,7 @@ SELECT (SELECT sum(VolBytes) FROM Media) AS nb_bytes, ($self->{sql}->{DB_SIZE}) AS db_size, (SELECT count(Job.JobId) - FROM Job + FROM Job $filter WHERE Job.JobStatus IN ('E','e','f','A') $limit ) AS nb_err, -- 2.39.5