[wp-meta] [Making WordPress.org] #5928: Add a row background color-coding legend to the top of the various core Trac reports

[Making WordPress.org]

#5928: Add a row background color-coding legend to the top of the various core
Trac reports
-------------------------+---------------------
 Reporter:  pbiron       |       Owner:  (none)
     Type:  enhancement  |      Status:  new
 Priority:  normal       |   Milestone:
Component:  Trac         |  Resolution:
 Keywords:               |
-------------------------+---------------------

Comment (by dd32):

 For some background for others, the colouring is very.. hidden and not
 understood by many, including those of us who use trac every day - Instead
 I infer it from the rows displayed directly..

 You can return 1..5 as the `__color__` field from a SQL report and that
 affects the row colours, by default I think it uses the priority field for
 that unless otherwise specified.

 I believe "no colour" is `3` IIRC.

 It [https://stackoverflow.com/questions/40888133/how-to-color-tickets-in-a
 -trac-report-by-component looks like we can customise the background
 colours] by returning a `__style__` field.

 To take https://core.trac.wordpress.org/tickets/major as an example..
 {{{
   CASE
   WHEN priority = 'highest omg bbq' OR severity IN ( 'critical', 'blocker'
 )
   THEN 1
   WHEN priority = 'high' OR severity = 'major'
   THEN 2
   WHEN priority IN ( 'low', 'lowest' ) OR severity IN ( 'trivial', 'minor'
 )
   THEN 4
   ELSE 0
   END AS __color__,
 }}}

 But https://core.trac.wordpress.org/tickets/minor has:
 {{{
   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%'
   THEN 1
   WHEN keywords LIKE '%early%'
   THEN 2
   ELSE 3
   END as __color__,
 }}}

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