Aklapper has uploaded a new change for review.
https://gerrit.wikimedia.org/r/69629
Change subject: Bugzilla Weekly Report: Don't list random products but top 5
......................................................................
Bugzilla Weekly Report: Don't list random products but top 5
Bug: 49845
Change-Id: Iecdc7439463f58be272cf0b73f662ac91d0b061b
---
M templates/misc/bugzilla_report.php
1 file changed, 4 insertions(+), 1 deletion(-)
git pull ssh://gerrit.wikimedia.org:29418/operations/puppet
refs/changes/29/69629/1
diff --git a/templates/misc/bugzilla_report.php
b/templates/misc/bugzilla_report.php
index bc025dd..61a26af 100755
--- a/templates/misc/bugzilla_report.php
+++ b/templates/misc/bugzilla_report.php
@@ -5,7 +5,7 @@
print "Created reports per product\n\n";
return <<<END
SELECT
- name, count(*)
+ name, count(*) as total
FROM
bugs
JOIN
@@ -20,6 +20,9 @@
"$end_date"
GROUP BY
product_id
+ORDER BY
+ total
+DESC
LIMIT 5;
END;
}
--
To view, visit https://gerrit.wikimedia.org/r/69629
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: Iecdc7439463f58be272cf0b73f662ac91d0b061b
Gerrit-PatchSet: 1
Gerrit-Project: operations/puppet
Gerrit-Branch: production
Gerrit-Owner: Aklapper <[email protected]>
_______________________________________________
MediaWiki-commits mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
