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; anonymous removed
  • 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 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.