Hi,
Here's what I'm trying to do.. I need to have a ticket report that
will bring up all user's activity to tickets within the last 7 days.
Here is what I have so far..
SELECT ticket, time as created, time, author, field, oldvalue,
newvalue from ticket_change WHERE author = $USER and julianday(time,
'unixepoch') > julianday('now')-7
ORDER BY time DESC
For some reason, this isn't working.. Is there anyone out there can
see what I'm doing wrong?
--
You received this message because you are subscribed to the Google Groups "Trac
Users" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/trac-users?hl=en.
