Edgewall Software

Changes between Initial Version and Version 1 of Ticket #8947, comment 19


Ignore:
Timestamp:
Mar 5, 2011, 12:27:39 PM (13 years ago)
Author:
Remy Blank

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #8947, comment 19

    initial v1  
    3737-               ORDER BY tc1.time
    3838-               """, (self.id,))
    39 +            SELECT tc1.time,COALESCE(tc2.oldvalue,''),
    40 +                   tc2.author,COALESCE(tc2.newvalue,'')
     39+            SELECT DISTINCT tc1.time,COALESCE(tc2.oldvalue,''),
     40+                            tc2.author,COALESCE(tc2.newvalue,'')
    4141+            FROM ticket_change AS tc1
    4242+            LEFT OUTER JOIN ticket_change AS tc2