Remove Component column from reports {9} and {10}

[Ryan J Ollos]

When on Trac 1.0, we should be able to make the following untested modifications to reports {9} and {10}, which will remove the Component column, group the tickets by Component and still allow the report to be sorted by any column.

• component -> component AS __group__
• ORDER BY p.value, severity, time -> ORDER BY __group__, @SORT_COLUMN@, p.value, severity, time

See #10478 and #10488 for related tickets.

[Ryan J Ollos]

Report {10} should also group by status (see comment:61:ticket:10193).

[Ryan J Ollos]

The changes in comment:description had already been made. Additional, a link to the project wiki page was added as a __grouplink__. The reports are now:

SELECT p.value AS __color__,
    id AS ticket, summary, '/wiki/' || component AS __grouplink__, component AS __group__, t.type, r.value AS release,
    owner, status,
    time AS created,
    changetime AS modified, description AS _description,
    reporter AS _reporter
  FROM ticket t
    LEFT OUTER JOIN ticket_custom r
    ON (t.id = r.ticket AND r.name = 'release')
    JOIN enum p ON p.name = t.priority AND p.type='priority'
  WHERE status <> 'closed'
    AND component = '$COMPONENT'
  ORDER BY __group__, @SORT_COLUMN@, p.value, severity, time

SELECT p.value AS __color__,
    id AS ticket, summary, '/wiki/' || component AS __grouplink__, component AS __group__, t.type, r.value AS release,
    owner, status,
    time AS created,
    changetime AS modified, description AS _description,
    reporter AS _reporter
  FROM ticket t
    LEFT OUTER JOIN ticket_custom r
    ON (t.id = r.ticket AND r.name = 'release')
    JOIN enum p ON p.name = t.priority AND p.type='priority'
  WHERE component = '$COMPONENT'
  ORDER BY __group__, status, @SORT_COLUMN@, p.value, severity, time

In the future we'll be able to group report {10} by status, but a Trac upgrade will be needed first: #11464.

[Ryan J Ollos]

Report {10} was not sorting by ticket id, so I made the following change:

-  ORDER BY __group__, status, @SORT_COLUMN@, p.value, severity, time
+  ORDER BY __group__, @SORT_COLUMN@, p.value, severity, time