-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
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')
CM Lubinski
Chris Nelson wrote:
> When viewing lists of tickets (either in reports, custom queries, or
> TicketQuery macro output), if I could see the last comment on the ticket, I
> could often avoid having to click through to see the ticket details. I
> haven't figured out a way to do that. Am I missing something? If now, how
> would you do that? Do we have to add a last_comment "column" to a core query
> handler or something? (I'm shooting in the dark; I really don't know that
> much about Trac internals.)
>
> Chris
> --
> Christopher Nelson, Software Engineering Manager
> SIXNET - Solutions for Your Industrial Networking Challenges
> 331 Ushers Road, Ballston Lake, NY 12019
> Tel: +1.518.877.5173, Fax: +1.518.877.8346 www.sixnet.com
>
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iEYEARECAAYFAkt8EpcACgkQfzi1OiZiJLAi1gCfTCud/Jlb7jITIr/sCMPScG7X
9SUAn3FkKThGHta1ddDJ2eyE8DZEBr3p
=ES8z
-----END PGP SIGNATURE-----
--
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.
