Hello, *I want to search by the closing date (ticket_change) and group the results by owner.* * * *I'm using dynamic parameter to get dates. I really want the closing date and so I'm using the table ticket_change.* * *
> SELECT p.value AS __color__, t.owner AS __group__, > id as ticket, summary, t.type, t.resolution, t.time as > created, > to_char(to_timestamp(tc.time/1000000),'DD-MM-YYYY') as closed > FROM ticket t, enum p, ticket_change tc > WHERE to_char(to_timestamp(tc.time/1000000),'DDMMYYYY') between > '$DATEBEGIN' > AND '$DATEEND' > AND p.name=t.priority AND p.type='priority' AND t.status = 'closed' > AND t.resolution='fixed' > AND tc.field='status' AND newvalue='closed' > ORDER BY t.owner The result is not correct. *Help me.* * * *Thanks* * * @ivanelson []s -- You received this message because you are subscribed to the Google Groups "Trac Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/trac-users?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
