Changeset 3037

Show
Ignore:
Timestamp:
01/11/08 15:14:25 (1 year ago)
Author:
khundeen
Message:

FIXED - # 2375: [patch] tracmetrixplugin works with postgresql
http://trac-hacks.org/ticket/2375

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved

  • tracmetrixplugin/0.11/tracmetrixplugin/mdashboard.py

    r3017 r3037  
    108108    ticket_list = ",".join(str_ids) 
    109109     
    110     sqlquery = "SELECT ticket.id, ticket.type, ticket.time, ticket.status, " \ 
     110    sqlquery = "SELECT ticket.id AS tid, ticket.type, ticket.time, ticket.status, " \ 
    111111                       "ticket_change.time, ticket.milestone, ticket_change.field, " \ 
    112112                       "ticket_change.oldvalue, ticket_change.newvalue " \ 
    …… 
    114114                       "WHERE (ticket_change.field='status' " \ 
    115115                       "OR ticket_change.field='milestone') AND ticket.id IN (%s) " \ 
    116                        "UNION SELECT ticket.id, ticket.type, ticket.time, ticket.status, " \ 
     116                       "UNION SELECT ticket.id AS tid, ticket.type, ticket.time, ticket.status, " \ 
    117117                       "ticket.time, ticket.milestone, null, null, null FROM ticket " \ 
    118118                       "WHERE ticket.time = ticket.changetime " \ 
    119                        "AND ticket.id IN (%s) ORDER BY ticket.id" % (ticket_list, ticket_list) 
     119                       "AND ticket.id IN (%s) ORDER BY tid" % (ticket_list, ticket_list) 
    120120         
    121121#    sqlquery = "SELECT ticket.id, ticket.type, ticket.time, ticket.status, " \