[[PageOutline(2-5,Contents,Pullout)]] = Show unread tickets == Description 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. [[Image(last.png, border=1, align=center)]] 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 a Trac environment upgrade is required. Of course, it does not work for anonymous users. [[Image(no_unread_metanav.png, border=1, align=center)]] I tested it on Trac 0.10 and current trunk of Trac 0.11. This plugin can be used in reports and a [source:tracunreadplugin/0.11/trac7_with_unread.sql sample SQL report for PostgreSQL] is included in distribution. Screenshot: [[Image(trac_unread_report.png, border=1, align=center)]] But there are limitations: First of all, you will need PostgreSQL (not tested with MySQL). SQLite lacks string functions required to extract comment number from "parent.reply" pair in the database, which invalidates the use of SQLite for this plugin. Then, you must dump all `_description`, `description_` and `_description_` fields from your report (they are hidden in default reports). 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). == Bugs/Feature Requests Existing bugs and feature requests for TracUnreadPlugin are [report:9?COMPONENT=TracUnreadPlugin here]. If you have any issues, create a [/newticket?component=TracUnreadPlugin new ticket]. [[TicketQuery(component=TracUnreadPlugin&group=type,format=progress)]] == Download Download the zipped source from [download:tracunreadplugin here]. == Source You can check out TracUnreadPlugin from [http://trac-hacks.org/svn/tracunreadplugin here] using Subversion, or [source:tracunreadplugin browse the source] with Trac. == Example A couple of screenshots: [[Image(last_metanav.png, border=1, align=center)]] attachment:last_metanav.png [[Image(no_unread_metanav.png, border=1, align=center)]] attachment:no_unread_metanav.png == Recent Changes [[ChangeLog(tracunreadplugin, 3)]] == Author/Contributors '''Author:''' [wiki:vnaum] [[BR]] '''Maintainer:''' [[Maintainer]] [[BR]] '''Contributors:'''