Redmine

Hi!

at least there is an idea on my own. Maybe someone could comment/help on this:

A convenient display of the last comment could be obtained by:

1) create a custom field last-comment for tickets
2) create a mysql-database-trigger which, whenever a new comment is inserted for a ticket, updates the last-comment with the new inserted comment.
3) so last-comment would contain always the freshest comment and could be easily added to ticket overview (using standard functionality)

Anybody done this or similar? Any advice?

thanks

Alex

2) create a mysql-database-trigger which, whenever a new comment is inserted for a ticket, updates the last-comment with the new inserted comment.

• You'd need 2 triggers (insert / update).
• While it is certainly possible to write such triggers, they'd need to parse the content column of the inserted or updated dataset...

=> In the end you'd have business logic in the database, which is generally not desirable.

A better way (IMHO) would be that you write a plugin that uses the controller_messages_new_after_save and controller_messages_reply_after_save plugin hooks from the messages_controller...
http://www.redmine.org/projects/redmine/repository/entry/trunk/app/controllers/messages_controller.rb

Thanks - sounds like a good idea!

Updating a custom field is trivial with the Custom Workflow plugin.

However, given that the last comment/note would most likely be long, it will clutter the issue view, and be unwieldy in the issues list/table view. (It would be useful for a filter and CSV export.)

Hi go2null,

checked this plugin and, YES: I think it will provide the functionality I need. I will give it a try during the next weeks.
(I need this functionality primarily for producing a PDF export for communication with an external software partner).
Another possibility would be bulk-PDF-export of tickets.

Thanks!

Alex