Aklapper has uploaded a new change for review.
https://gerrit.wikimedia.org/r/52401
Change subject: [bug 45770] Add a getHighestPrioTickets() SQL query, not used
yet
......................................................................
[bug 45770] Add a getHighestPrioTickets() SQL query, not used yet
Change-Id: I9dd761d21eb887cb7fd43045bac007e5f0f2ca73
---
M templates/misc/bugzilla_report.php
1 file changed, 27 insertions(+), 0 deletions(-)
git pull ssh://gerrit.wikimedia.org:29418/operations/puppet
refs/changes/01/52401/1
diff --git a/templates/misc/bugzilla_report.php
b/templates/misc/bugzilla_report.php
index 6f9ea0f..102c1db 100755
--- a/templates/misc/bugzilla_report.php
+++ b/templates/misc/bugzilla_report.php
@@ -135,6 +135,33 @@
END;
}
+function getHighestPrioTickets() {
+ return <<<END
+
+SELECT
+ products.name AS product,
+ components.name AS component,
+ bugs.bug_id,
+ bugs.short_desc as bugsummary,
+ profiles.login_name AS assignee,
+ bugs.delta_ts,
+ bugs.priority
+FROM
+ bugs
+JOIN
+ profiles ON assigned_to = profiles.userid
+JOIN
+ products ON bugs.product_id = products.id
+ JOIN components ON bugs.component_id = components.id
+WHERE
+ resolution = ""
+AND
+ priority = "Highest" OR priority = "Immediate"
+ORDER BY
+ product, component, delta_ts
+LIMIT 200;
+END;
+}
function formatOutput($result) {
while ($row = mysql_fetch_row($result)) {
--
To view, visit https://gerrit.wikimedia.org/r/52401
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: I9dd761d21eb887cb7fd43045bac007e5f0f2ca73
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
