Project

General

Profile

"Last comment" conveniently displayed?

Added by Anonymous almost 10 years ago

Hi!

in communication with co-workers who do not have access to our Redmine, I use ticket-Lists exported as PDF to discuss status and next steps on Issues/Projects. It would be extremely useful to export also the last comment (latest comment) which usually reflects what we agreed upon and intend to do next.

I have searched a lot but found no possibility/plugin to create a pseudo-column containing this information. There is a similar feature request (#5294) which was closed.

Idea: is it possible to create a Redmine-Macro which (dynamically) fills a custom field on export with this information? Who could help on this?
Or ist there an other method out there?

Any ideas/help appreciated.

Thanks

Alex


Replies (5)

RE: "Last comment" conveniently displayed? - Added by Anonymous over 9 years ago

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

RE: "Last comment" conveniently displayed? - Added by Jan Niggemann (redmine.org team member) over 9 years ago

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.

Some thoughts on this:
  • 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

RE: "Last comment" conveniently displayed? - Added by Anonymous over 9 years ago

Thanks - sounds like a good idea!

RE: "Last comment" conveniently displayed? - Added by @ go2null over 9 years ago

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

RE: "Last comment" conveniently displayed? - Added by Anonymous over 9 years ago

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

    (1-5/5)