diff options
| author | gerv%gerv.net <> | 2002-09-11 22:56:35 +0200 |
|---|---|---|
| committer | gerv%gerv.net <> | 2002-09-11 22:56:35 +0200 |
| commit | 3ca52bba011446c4e2d897f98847c2c3d4ea51cd (patch) | |
| tree | e6ed499d77a53dc2bb9e02caf23309dbd60c7597 | |
| parent | d7b93f801f37f050959058eb48f5e58686e78254 (diff) | |
| download | bugzilla-3ca52bba011446c4e2d897f98847c2c3d4ea51cd.tar.gz bugzilla-3ca52bba011446c4e2d897f98847c2c3d4ea51cd.tar.xz | |
Bug 166821 - reports.cgi broken by recent schema changes. r=bbaetz.
| -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 |