Show unread tickets


This plugin tracks ticket page views and provides "last unread" link on ticket pages, ie those pages that end with /ticket/XYZ. This is similar to a feature you have probably seen on most forums:

"last unread" screenshot

The only difference is that this plugin does not just use your last login time, but actually tracks time when you requested each ticket. This is also the reason that a Trac environment upgrade is required.

Of course, it does not work for anonymous users:

"no unread" screenshot

Tested on Trac 0.10 and current trunk of Trac 0.11.

This plugin can be used in reports and a sample SQL report for PostgreSQL is included in its distribution:

report screenshot

Known limitations:

  1. This plugin works with PostgreSQL: SQLite lacks string functions required to extract comment number from "parent.reply" pair in the database. Nor has it been tested with MySQL.
  2. Also, you must dump all _description, description_ and _description_ fields from your report (they are hidden in default reports). The reason is that these fields provide the link to "unread comment". The only way to include another link to report row is generating wiki markup in description field. This could be improved however, and patches welcome.

Bugs/Feature Requests

Existing bugs and feature requests for TracUnreadPlugin are here.

If you have any issues, create a new ticket.


3 / 3


1 / 1


0 / 1


Download the zipped source from here.


You can check out TracUnreadPlugin from here using Subversion, or browse the source with Trac.


General instructions on installing Trac plugins can be found on the TracPlugins page.

Recent Changes

5523 by vnaum on 2009-04-16 12:13:21
sample report should now work with PostgreSQL 8.3 (cast as char).
suggested by christian@…
4362 by vnaum on 2008-10-01 04:43:29
Bug#3830 (trac-admin initenv with --inherit option fails) should be fixed now
3935 by vnaum on 2008-07-02 12:00:18
Merging changes from 0.10 branch (portable table creation)


Author: vnaum
Maintainer: Vladislav Naumov

Last modified 8 years ago Last modified on Aug 11, 2016, 5:57:20 PM

Attachments (3)

Download all attachments as: .zip