https://bugzilla.wikimedia.org/show_bug.cgi?id=49758

       Web browser: ---
            Bug ID: 49758
           Summary: Add "product"output  to Weekly Bugzilla Report email
                    for "new bugs in component"
           Product: Wikimedia
           Version: wmf-deployment
          Hardware: All
                OS: All
            Status: NEW
          Severity: minor
          Priority: Unprioritized
         Component: Bugzilla
          Assignee: [email protected]
          Reporter: [email protected]
                CC: [email protected], [email protected],
                    [email protected]
    Classification: Unclassified
   Mobile Platform: ---

See http://lists.wikimedia.org/pipermail/wikitech-l/2013-June/070006.html for
confusion.

Query (untested!) should probably become

SELECT product.name, component.name, count(*) as total FROM bugs JOIN
components on bugs.component_id = components.id JOIN products on
bugs.product_id = products.id WHERE creation_ts BETWEEN "$begin_date" AND
"$end_date" GROUP BY component_id ORDER BY total DESC LIMIT 5;

in
https://git.wikimedia.org/blob/operations%2Fpuppet.git/HEAD/templates%2Fmisc%2Fbugzilla_report.php
line 27

-- 
You are receiving this mail because:
You are the assignee for the bug.
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l

Reply via email to