[wp-meta] [Making WordPress.org] #8047: Candidates for Closure requirements?

[Making WordPress.org]

#8047: Candidates for Closure requirements?
--------------------------+----------------------
 Reporter:  SirLouen      |       Owner:  (none)
     Type:  defect (bug)  |      Status:  closed
 Priority:  normal        |   Milestone:
Component:  Trac          |  Resolution:  invalid
 Keywords:                |
--------------------------+----------------------
Changes (by dd32):

 * status:  new => closed
 * resolution:   => invalid


Comment:

 @SirLouen Some things are better as a Slack discussion, the Core team
 manages their own reports, you don't need to ask Meta for that.

 > `Tickets in the $COMPONENT component`
 {{{
 SELECT
   CASE
   WHEN milestone LIKE '_.%'
   THEN 'Slated for Next Release'
   WHEN milestone = 'Awaiting Review' AND (keywords LIKE
 '%reporter_feedback%' OR keywords LIKE '%close%' OR keywords LIKE
 '%2nd_opinion%')
   THEN 'Candidates for Closure'
   WHEN milestone = 'Awaiting Review'
   THEN 'Tickets Awaiting Review'
   WHEN strftime("%%s", current_date) - 31536000 >= changetime / 1000000
   THEN 'Tickets Not Modified in a Year'
   WHEN keywords LIKE '%feedback%'
   THEN 'Tickets Needing Feedback'
   WHEN keywords LIKE '%has_patch%'
   THEN 'Tickets with Patches'
   WHEN type = 'defect (bug)'
   THEN 'Unpatched Bugs'
   ELSE 'Unpatched Enhancements'
   END as __group__,
 ....

   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,

 }}}

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