Changeset 3075

Show
Ignore:
Timestamp:
01/17/08 06:04:42 (1 year ago)
Author:
coling
Message:

Fixes #2431. Thanks for the report. If there are any more postgres issues please let me know.

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved

  • worklogplugin/0.11/worklog/manager.py

    r3063 r3075  
    289289        elif mode == 'summary': 
    290290            cursor.execute('SELECT wl.worker, s.value, wl.starttime, wl.endtime, wl.ticket, t.summary, t.status, wl.comment ' 
    291                            'FROM (SELECT worker,MAX(lastchange) lastchange FROM work_log GROUP BY worker) wlt ' 
     291                           'FROM (SELECT worker,MAX(lastchange) AS lastchange FROM work_log GROUP BY worker) wlt ' 
    292292                           'INNER JOIN work_log wl ON wlt.worker=wl.worker AND wlt.lastchange=wl.lastchange ' 
    293293                           'INNER JOIN ticket t ON wl.ticket=t.id '