From af00161996a15e545573c29ccac52185eeb9b9dd Mon Sep 17 00:00:00 2001 From: "bugreport%peshkin.net" <> Date: Tue, 5 Apr 2005 06:02:16 +0000 Subject: Bug 286461:Add products table to search if classification are needed Patch by joel r=gerv, a=justdave --- Bugzilla/Search.pm | 4 ++++ 1 file changed, 4 insertions(+) (limited to 'Bugzilla') diff --git a/Bugzilla/Search.pm b/Bugzilla/Search.pm index 1f8e53ea3..0283b7f76 100644 --- a/Bugzilla/Search.pm +++ b/Bugzilla/Search.pm @@ -139,6 +139,8 @@ sub init { push @supptables, "INNER JOIN classifications AS map_classifications " . "ON map_products.classification_id = map_classifications.id"; + push @supptables, "INNER JOIN products AS map_products " . + "ON bugs.product_id = map_products.id"; } if (lsearch($fieldsref, 'map_components.name') >= 0) { @@ -863,6 +865,8 @@ sub init { "^classification,(?!changed)" => sub { # Generate the restriction condition + push @supptables, "INNER JOIN products AS map_products " . + "ON bugs.product_id = map_products.id"; $f = $ff = "classifications.name"; $funcsbykey{",$t"}->(); $term = build_subselect("map_products.classification_id", -- cgit v1.2.3-24-g4f1b