Modify

Opened 2 years ago

Closed 14 months ago

Last modified 11 months ago

#10510 closed enhancement (fixed)

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

Reported by: rjollos Owned by: rjollos
Priority: normal Component: TracHacks
Severity: normal Keywords:
Cc: otaku42, hasienda, osimons Trac Release: 1.0

Description (last modified by rjollos)

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.

Attachments (4)

After.png (38.3 KB) - added by rjollos 21 months ago.
Before.png (36.3 KB) - added by rjollos 21 months ago.
Report9After.png (39.3 KB) - added by rjollos 21 months ago.
Report9-Before.png (45.1 KB) - added by rjollos 21 months ago.

Download all attachments as: .zip

Change History (10)

comment:1 Changed 2 years ago by rjollos

  • Trac Release changed from 0.12 to 1.0

comment:2 Changed 21 months ago by rjollos

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

comment:3 Changed 21 months ago by rjollos

  • Status changed from new to assigned

comment:4 Changed 21 months ago by rjollos

  • Description modified (diff)

Changed 21 months ago by rjollos

Changed 21 months ago by rjollos

Changed 21 months ago by rjollos

Changed 21 months ago by rjollos

comment:5 Changed 14 months ago by rjollos

  • Resolution set to fixed
  • Status changed from assigned to closed

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.

comment:6 Changed 11 months ago by rjollos

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

Add Comment

Modify Ticket

Action
as closed The owner will remain rjollos.
The resolution will be deleted. Next status will be 'reopened'.
Author


E-mail address and user name can be saved in the Preferences.

 
Note: See TracTickets for help on using tickets.