Modify

Opened 2 years ago

Closed 2 years ago

Last modified 2 years ago

#10478 closed defect (fixed)

Can we add modification date to report 9

Reported by: ChrisNelson Owned by: rjollos
Priority: normal Component: TracHacks
Severity: normal Keywords:
Cc: hasienda 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 2 years ago by rjollos

  • Cc hasienda added
  • Owner changed from otaku42 to rjollos
  • Status changed from new to 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 follow-up: Changed 2 years ago by rjollos

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

comment:3 Changed 2 years ago by rjollos

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

comment:4 in reply to: ↑ 2 Changed 2 years ago by ChrisNelson

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

Replying to rjollos:

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

Perfect. Thanks!

comment:5 Changed 2 years ago by rjollos

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

Add Comment

Modify Ticket

Action
as closed .
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.