summaryrefslogtreecommitdiffstats
path: root/extensions/ProductDashboard/lib/Queries.pm
diff options
context:
space:
mode:
Diffstat (limited to 'extensions/ProductDashboard/lib/Queries.pm')
-rw-r--r--extensions/ProductDashboard/lib/Queries.pm7
1 files changed, 5 insertions, 2 deletions
diff --git a/extensions/ProductDashboard/lib/Queries.pm b/extensions/ProductDashboard/lib/Queries.pm
index 43d799111..63362f5bf 100644
--- a/extensions/ProductDashboard/lib/Queries.pm
+++ b/extensions/ProductDashboard/lib/Queries.pm
@@ -220,10 +220,12 @@ sub by_value_summary {
}
sub by_assignee {
- my ($product, $bug_status) = @_;
+ my ($product, $bug_status, $limit) = @_;
my $dbh = Bugzilla->dbh;
my $extra;
+ $limit = detaint_natural($limit) ? $dbh->sql_limit($limit) : "";
+
$extra = "AND bugs.bug_status IN (" . open_states() . ")" if $bug_status eq 'open';
$extra = "AND bugs.bug_status IN (" . closed_states() . ")" if $bug_status eq 'closed';
@@ -234,7 +236,8 @@ sub by_assignee {
AND bugs.assigned_to = profiles.userid
$extra
GROUP BY profiles.login_name
- ORDER BY COUNT(bugs.bug_id) DESC", undef, $product->id)};
+ ORDER BY COUNT(bugs.bug_id) DESC $limit",
+ undef, $product->id)};
return \@result;
}