[wp-meta] [Making WordPress.org] #6508: Make Report 27 dynamic

[Making WordPress.org]

#6508: Make Report 27 dynamic
-----------------------------+---------------------
 Reporter:  desrosj          |       Owner:  (none)
     Type:  feature request  |      Status:  new
 Priority:  normal           |   Milestone:
Component:  Trac             |  Resolution:
 Keywords:                   |
-----------------------------+---------------------

Comment (by dd32):

 > Would it be possible to dynamically include the Bug Gardener and
 Component Maintainer Group Members from the Trac admin? That would ensure
 this report is up to date without having to manually update the query all
 the time.

 At first my response here was `No - Trac reporting is SQL and has limited
 substitutions`.. however, it's SQL, and the User Groups are SQL..

 So I've replaced the horribly out-of-date static user list it was using to
 using this SQL:
 {{{ AND t.owner IN ( SELECT DISTINCT username FROM permission WHERE action
 IN ( 'Committer', 'Bug Gardener', 'Component Maintainer' ) ) }}}

 > Also wondering how best to group this page. Not sure if by milestone, or
 by the trusted contributor that's matched, or something else.

 I could see grouping by component being useful, owner, or even by last
 modified.

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