Show unread tickets
This plugin tracks ticket page views and provides "last unread" link on ticket pages (those that end with /ticket/XYZ). Similar to one you've probably seen on most forums.
The only difference is that this plugin is better: it does not just uses your last login time, but actually tracks time when you requested each ticket - and that's why trac environment upgrade is required.
Of course, it does not work for anonymous users.
I tested it on Trac 0.10 and current trunk of 0.11.
Can I use it in reports?
Yes, you can.
Sample SQL report for PostgreSQL is included in distribution.
And here is screenshot:
But there are limitations.
First of all, you will need PostgreSQL (I'm pretty sure Mysql will work too, but I just don't have trac instance with this backend). SQLite lacks string functions required to extract comment number from "parent.reply" pair in the database (and you want your link to go directly to unread comment, not just to a ticket, right?).
Then, you must dump all _description, description_ and _description_ fields from your report (they are hidden in default reports anyway). Reason: we will need this field to provide link to "unread comment". The only way to include another link to report row is generating wiki markup in description field. At least, I found no other way (in Trac 0.10.4).
If you have any issues, create a new ticket.
Download the zipped source from here.
A couple of screenshots:
sample report should now work with PostgreSQL 8.3 (cast t.id as char). suggested by email@example.com
Merging changes from 0.10 branch (portable table creation)
Debug code removed Version is now "0.0.2"
- last_metanav.png (2.8 kB) -
"last unread" screenshot, added by vnaum on 04/20/08 15:36:20.
- no_unread_metanav.png (2.8 kB) -
"no unread" screenshot, added by vnaum on 04/20/08 15:36:41.
- trac_unread_report.png (13.8 kB) -
report screenshot, added by vnaum on 04/20/08 15:36:58.
- last.png (2.8 kB) - added by vnaum on 04/20/08 15:54:03.