CM Lubinski wrote:
> This is possible when using custom reports. Here's an untested, but
> simple example:
> 
> SELECT
>   t.id,
>   c.newvalue AS Comment
>   FROM ticket t
>     LEFT JOIN ticket_change c ON (t.changetime = c.time
>       AND t.id = c.ticket AND c.field='comment')

Thanks.  I can work with that.

It sure would be nice to put in a TicketQuery, though.

-- 
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.

Reply via email to