Modify ↓

Opened 12 years ago

Closed 12 years ago

Last modified 12 years ago

#10478 closed defect (fixed)

Can we add modification date to report 9

Reported by: Chris Nelson Owned by: Ryan J Ollos
Priority: normal Component: TracHacks
Severity: normal Keywords:
Cc: Steffen Hoffmann Trac Release: 0.12

Description

It would be nice to be able to sort tickets by when they were last touched. For example, if a user comments on one of my tickets, I'd like to be able to go to {9} and sort by modified to see which it is.

Attachments (0)

Change History (5)

comment:1 Changed 12 years ago by Ryan J Ollos

Cc: Steffen Hoffmann added; anonymous removed
Owner: changed from Michael Renzmann to Ryan J Ollos
Status: new → assigned

Good idea. Done.

  • (a) orig_report vs. (b) modified_report 

    $ diff -u orig_report modified_report
    a b  
    22   id AS ticket, summary, component, severity,
    33   (CASE status WHEN 'assigned' THEN owner||' *' ELSE owner END) AS owner,
    44   time AS created,
    5    changetime AS _changetime, description AS _description,
     5   changetime AS modified, description AS _description,
    66   reporter AS _reporter
    77  FROM ticket t, enum p
    88  WHERE status IN ('new', 'assigned', 'reopened')

comment:2 Changed 12 years ago by Ryan J Ollos

Please report back if this is to your satisfaction. Here is an example.

comment:3 Changed 12 years ago by Ryan J Ollos

For consistency, {10} was modified in the same way. Here is an example.

comment:4 in reply to:  2 Changed 12 years ago by Chris Nelson

Resolution: → fixed
Status: assigned → closed

Replying to rjollos:

Please report back if this is to your satisfaction. Here is an example.

Perfect. Thanks!

comment:5 Changed 12 years ago by Ryan J Ollos

#10488 is a follow-on to this ticket, with some other ideas for changing the reports.

Modify Ticket

Change Properties
Set your email in Preferences
Action
as closed The owner will remain Ryan J Ollos.
The resolution will be deleted. Next status will be 'reopened'.

Add Comment

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

Attachments ↑ Description ↑
 
Note: See TracTickets for help on using tickets.