Redmine

We use a "Last note" custom field and a custom workflow.

If required, we could possibly break it out into a plugin.

related to #1474

Our company could also greatly profit from this additional query functionality.

This is how I solved it locally:

added to the issue:

      def last_note
       if !journals || !(journal = journals.where("notes <> ''").last)
         @last_note ||= "" 
       else
         @last_note ||= journal.notes
       end

added to issue_query:

            available_columns << QueryColumn.new(:last_note,
              :caption => :field_notes_last,
              :totalable => false,
              :inline => false
            ) unless columns.detect{ |c| c.name == :last_note } 

but this does not check for security, private notes, etc.
sorry for not providing as a patch...