diff options
author | 2002-09-11 20:56:35 +0000 | |
---|---|---|
committer | 2002-09-11 20:56:35 +0000 | |
commit | 3ca52bba011446c4e2d897f98847c2c3d4ea51cd (patch) | |
tree | e6ed499d77a53dc2bb9e02caf23309dbd60c7597 /reports.cgi | |
parent | Bug 167595 - Query - multiple-select product (and probably component) broken (diff) | |
download | bugzilla-3ca52bba011446c4e2d897f98847c2c3d4ea51cd.tar.gz bugzilla-3ca52bba011446c4e2d897f98847c2c3d4ea51cd.tar.bz2 bugzilla-3ca52bba011446c4e2d897f98847c2c3d4ea51cd.zip |
Bug 166821 - reports.cgi broken by recent schema changes. r=bbaetz.
Diffstat (limited to 'reports.cgi')
-rwxr-xr-x | reports.cgi | 9 |
1 files changed, 7 insertions, 2 deletions
diff --git a/reports.cgi b/reports.cgi index f557ac7f6..13c8406ee 100755 --- a/reports.cgi +++ b/reports.cgi @@ -769,9 +769,14 @@ sub most_recently_doomed { ######################### # Build up $query string - my $query = "select distinct assigned_to from bugs where bugs.bug_status='NEW' and target_milestone='' and bug_severity!='enhancement' and status_whiteboard='' and (product='Browser' or product='MailNews')"; + my $query = "SELECT DISTINCT assigned_to FROM bugs, products + WHERE bugs.bug_status = 'NEW' + AND target_milestone = '' + AND bug_severity != 'enhancement' + AND status_whiteboard = '' + AND bugs.product_id = products.id"; if ($FORM{'product'} ne "-All-" ) { - $query .= "and bugs.product=".SqlQuote($FORM{'product'}); + $query .= "AND products.name =".SqlQuote($FORM{'product'}); } # End build up $query string |