Edgewall Software

Changes between Initial Version and Version 3 of Ticket #8120


Ignore:
Timestamp:
Apr 10, 2009, 12:42:04 AM (15 years ago)
Author:
Christian Boos
Comment:

I modified slightly your report (diffs can be seen using … the (diff) link and original version can be obtained by looking at ticket:8120?version=0, adding a missing AS, removing the datetime functions and changing the time column names to known names, as documented in TracReports#Automaticallyformattedcolumns.

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #8120

    • Property Status new → closed
    • Property Resolution → worksforme
    • Property Milestone 0.12

  • Ticket #8120 – Description

    initial v3  
    8080  T.type,
    8181  T.status,
    82   datetime ( T.time, 'unixepoch', 'localtime' ) AS createtime,
     82  T.time AS created,
    8383  D.value AS due_date,
    84   datetime ( T.changetime, 'unixepoch', 'localtime' ) AS changetime,
     84  T.changetime AS modified,
    8585  T.priority,
    8686  WUPT.value AS _wup_ticket,
    … …  
    9595    SA2.sid = T.reporter AND
    9696    SA2.name = 'name'
    97   ) || ' (' || T.reporter || ')' reporter_name,
     97  ) || ' (' || T.reporter || ')' AS reporter_name,
    9898  W.value AS _resolution_status,
    9999  T.description AS _description_,