From f19bc912f3d45ac6316fd005ce1053e167767e42 Mon Sep 17 00:00:00 2001 From: Dave Lawrence Date: Thu, 21 Mar 2013 09:59:01 -0400 Subject: Bug 853328 - product/component searching should also search the product's description. --- extensions/ProdCompSearch/lib/WebService.pm | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) (limited to 'extensions') diff --git a/extensions/ProdCompSearch/lib/WebService.pm b/extensions/ProdCompSearch/lib/WebService.pm index dea2e5e51..2e2592879 100644 --- a/extensions/ProdCompSearch/lib/WebService.pm +++ b/extensions/ProdCompSearch/lib/WebService.pm @@ -63,7 +63,8 @@ sub prod_comp_search { my $sql_word = $dbh->quote($word); trick_taint($sql_word); # note: CONCAT_WS is MySQL specific - my $field = "CONCAT_WS(' ', products.name, components.name, components.description)"; + my $field = "CONCAT_WS(' ', products.name, products.description, + components.name, components.description)"; push(@list, $dbh->sql_iposition($sql_word, $field) . " > 0"); } } -- cgit v1.2.3-24-g4f1b