-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 02.06.2013 09:19, Ivanelson Nunes wrote: > 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 <http://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.
Because you're after the LAST closing date/time right? As you may guess, this has been asked before [1]. Steffen Hoffmann [1] http://stackoverflow.com/questions/13093221#13129262 -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.10 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAlGrXDIACgkQ31DJeiZFuHdi3QCgkVmTM1HvwtzJ4guHekWXfQR0 mD0AoI/cK7avywk5jW0yBYnAm2+Wz2VR =OT+5 -----END PGP SIGNATURE----- -- 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.
