summaryrefslogtreecommitdiffstats
path: root/summarize_time.cgi
diff options
context:
space:
mode:
Diffstat (limited to 'summarize_time.cgi')
-rwxr-xr-xsummarize_time.cgi10
1 files changed, 6 insertions, 4 deletions
diff --git a/summarize_time.cgi b/summarize_time.cgi
index 8992918cc..ab8a6bf50 100755
--- a/summarize_time.cgi
+++ b/summarize_time.cgi
@@ -236,8 +236,9 @@ sub query_work_by_buglist {
WHERE longdescs.bug_id IN ($buglist) AND
longdescs.who = profiles.userid AND
bugs.bug_id = longdescs.bug_id
- $date_bits
- GROUP BY longdescs.bug_id, profiles.login_name
+ $date_bits } .
+ $dbh->sql_group_by('longdescs.bug_id, profiles.login_name',
+ 'bugs.short_desc, bugs.bug_status') . qq{
ORDER BY longdescs.bug_when};
my $sth = $dbh->prepare($q);
$sth->execute(@{$date_values});
@@ -314,8 +315,9 @@ sub get_inactive_bugs {
FROM longdescs, bugs
WHERE longdescs.bug_id IN ($buglist) AND
bugs.bug_id = longdescs.bug_id
- $date_bits
- GROUP BY longdescs.bug_id
+ $date_bits } .
+ $dbh->sql_group_by('longdescs.bug_id',
+ 'bugs.short_desc, bugs.bug_status') . qq{
ORDER BY longdescs.bug_when};
$sth = $dbh->prepare($q);
$sth->execute(@{$date_values});