[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/25 {25} My Patches

 {{{
 #!sql
 -- ## 25: My Patches ## --

 -- {{{
 -- #!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]
 -- }}}
 --
 --  * Tickets that you've contributed a patch to
 --  * Sort by component, type, summary
 --  * Accepted tickets have an '*' appended to their owner's name
 --
 -- ,,Hidden feature: /my-patches?USER=$name pulls up someone else's patch
 list.,,

 SELECT
   CASE
   WHEN keywords LIKE '%needs_unit_tests%' OR keywords LIKE '%needs_docs%'
   THEN 3
   WHEN keywords LIKE '%close%' OR keywords LIKE '%needs_review%'
     OR keywords LIKE '%dev_feedback%' OR keywords LIKE '%2nd_opinion%'
   THEN 2
   WHEN keywords LIKE '%reporter_feedback%'
   THEN 3
   WHEN keywords LIKE '%commit%' OR keywords LIKE '%tested%'
   THEN 1
   WHEN keywords LIKE '%early%'
   THEN 2
   ELSE 3
   END as __color__,
   CASE
   WHEN milestone <= ( SELECT min(name) FROM milestone WHERE completed = 0
 AND name NOT LIKE '%.%.%' )
   THEN 'Next Release'
   ELSE 'Future Releases'
   END as __group__,
   t.id AS ticket,
   summary,
   CASE
   WHEN status = 'accepted'
   THEN t.owner || '*'
   WHEN t.owner <> 'anonymous'
   THEN t.owner
   ELSE ''
   END as owner,
   component,
   version as _version,
   priority as priority,
   severity,
   milestone as milestone,
   t.type AS type,
   status AS _status,
   CASE
   WHEN keywords LIKE '%needs_unit_tests%'
   THEN 'needs-unit-tests'
   WHEN keywords LIKE '%needs_docs%'
   THEN 'needs-docs'
   WHEN keywords LIKE '%close%'
   THEN 'close'
   WHEN keywords LIKE '%needs_review%'
   THEN 'needs-review'
   WHEN keywords LIKE '%dev_feedback%' OR keywords LIKE '%2nd_opinion%'
   THEN 'dev-feedback'
   WHEN keywords LIKE '%reporter_feedback%'
   THEN 'reporter-feedback'
   WHEN keywords LIKE '%commit%'
   THEN 'commit'
   WHEN keywords LIKE '%tested%'
   THEN 'tested'
   WHEN keywords LIKE '%has_patch%'
     OR keywords LIKE '%needs_testing%' AND keywords NOT LIKE
 '%needs_patch%'
   THEN 'has-patch'
   WHEN keywords LIKE '%early%'
   THEN 'early'
   ELSE ''
   END as workflow,
   t.time AS _created,
   changetime AS modified,
   t.description AS _description,
   reporter AS _reporter
 FROM ticket t
 JOIN attachment a
   ON a.type = 'ticket' AND a.id = t.id AND LOWER(author) = LOWER($USER)
   AND ( filename LIKE '%.diff' OR filename LIKE '%.patch' )
   WHERE status <> 'closed'
 GROUP BY t.id
 ORDER BY
   milestone <= ( SELECT min(name) FROM milestone WHERE completed = 0 AND
 name NOT LIKE '%.%.%' ) DESC,
   Component, t.type, summary
 }}}

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