[wp-meta] [Making WordPress.org] #2033: Add various Trac reports to meta.trac.wordpress.org

[Making WordPress.org]

#2033: Add various Trac reports to meta.trac.wordpress.org
--------------------+------------------
 Reporter:  netweb  |       Owner:
     Type:  defect  |      Status:  new
 Priority:  normal  |   Milestone:
Component:  Trac    |  Resolution:
 Keywords:          |
--------------------+------------------

Comment (by netweb):

 https://core.trac.wordpress.org/report/29 {29} Open Tickets with patches
 from you
 {{{
 #!sql
 -- ## 29: Open Tickets with patches from you ## --

 -- {{{
 -- #!span class="create-new-ticket button button-large button-primary"
 --
 [https://login.wordpress.org/?redirect_to=https://meta.trac.wordpress.org/newticket
 Create a new ticket]
 -- }}}
 --
 -- This report highlights any tickets which the current user has added
 patches on, Yet the ticket remains open.
 --
 -- By default, It shows for the current user, however, you may define it
 via the URL as such: http://core.trac.wordpress.org/report/29?USER=dd32
 --
 -- Coloured rows are those where the ticket has been marked as needing a
 patch.

 SELECT
   a.filename as `_filename`,
   t.id as ticket,
   CASE
     WHEN milestone = 'Future Release'
       THEN 'Future'
     ELSE milestone
    END as Milestone,
   status || ' ' || t.type as type,
   summary,
   CASE
     WHEN keywords LIKE '%commit%'
       THEN 'commit'
     WHEN keywords LIKE '%dev_feedback%'
       THEN 'dev-feedback'
     WHEN keywords LIKE '%2nd_opinion%'
       THEN '2nd-opinion'
     WHEN keywords LIKE '%reporter_feedback%'
       THEN 'reporter-feedback'
     WHEN keywords LIKE '%tested%'
       THEN 'tested'
     WHEN keywords LIKE '%needs_testing%'
       THEN 'needs-testing'
     WHEN keywords LIKE '%has_patch%'
       THEN 'has-patch'
     ELSE 'needs-patch'
   END as workflow,
   CASE
     WHEN keywords LIKE '%%needs-patch%%' OR keywords = ''
       THEN 'background: #ffcc66;'
     ELSE ''
    END as __style__,
   component,
   version,
   severity,
   priority,
   a.time AS modified,
   t.description as _description

 FROM
   attachment as a
   LEFT JOIN ticket as t ON a.id = t.id

 WHERE
   LOWER(a.Author) = LOWER('$USER')
   AND t.status != 'closed'

 GROUP BY t.id

 ORDER BY
   t.milestone ASC,
   a.time DESC,
   t.version ASC
 }}}

--
Ticket URL: <https://meta.trac.wordpress.org/ticket/2033#comment:2>
Making WordPress.org <https://meta.trac.wordpress.org/>
Making WordPress.org