wiki:TracUnreadPlugin

Version 13 (modified by figaro, 3 years ago) (diff)

Cosmetic changes, tagged wtih nolicense

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.

No image "last.png" attached to TracUnreadPlugin

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.

"no unread" screenshot

I tested it 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 distribution.

Screenshot:

report screenshot

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

If you have any issues, create a new ticket.

defect

3 / 3

enhancement

1 / 1

task

0 / 1

Download

Download the zipped source from [download:tracunreadplugin here].

Source

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

Example

A couple of screenshots:

"last unread" screenshot attachment:last_metanav.png

"no unread" screenshot attachment:no_unread_metanav.png

Recent Changes

5523 by vnaum on 2009-04-16 12:13:21
sample report should now work with PostgreSQL 8.3 (cast t.id 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)
(more)

Author/Contributors

Author: vnaum
Maintainer: Vladislav Naumov
Contributors:

Attachments (3)

Download all attachments as: .zip