Redmine

    when :last_notes

      item.last_notes.present? ? content_tag('div', textilizable(item, :last_notes), :class => "wiki") : ''

    @last_notes = nil

  def last_notes

    if @last_notes

      @last_notes

    else

      notes = self.journals.visible.where.not(notes: '').to_a

      notes.last.notes unless notes.empty?

    end

  end

  # Preloads visible last notes for a collection of issues

  def self.load_visible_last_notes(issues, user=User.current)

    if issues.any?

      issue_ids = issues.map(&:id)

      notes = Journal.joins(issue: :project).where.not(notes: '').

        where(Journal.visible_notes_condition(User.current, :skip_pre_condition => true)).

        where(:issues => {:id => issue_ids}).order("#{Journal.table_name}.id ASC").to_a

      issues.each do |issue|

        note = notes.select{|note| note.journalized_id == issue.id}

        issue.instance_variable_set "@last_notes", (note.empty? ? '' : note.last.notes)

      end

    end

  end

    QueryColumn.new(:description, :inline => false),

    QueryColumn.new(:last_notes, :caption => :label_last_notes, :inline => false)

    if has_column?(:last_notes)

      Issue.load_visible_last_notes(issues)

    end

    <td colspan="<%= @query.inline_columns.size + 1 %>" class="<%= column.css_classes %>">

      <% if query.block_columns.count > 1 %>

        <span><%= column.caption %></span>

      <% end %>

      <%= text %>

    </td>

    <label><%= check_box_tag 'c[]', 'last_notes', @query.has_column?(:last_notes) %> <%= l(:label_last_notes) %></label>

    <td colspan="<%= @query.inline_columns.size + 1 %>" class="<%= column.css_classes %>">

    <% if query.block_columns.count > 1 %>

      <span><%= column.caption %></span>

    <% end %>

    <%= text %>

    </td>

  label_last_notes: Last notes

          # use full width if the description or last_notes are displayed

          if table_width > 0 && (query.has_column?(:description) || query.has_column?(:last_notes))

            if query.has_column?(:last_notes) && issue.last_notes.present?

              pdf.set_x(10)

              pdf.set_auto_page_break(true, bottom_margin)

              pdf.RDMwriteHTMLCell(0, 5, 10, '', issue.last_notes.to_s, [], "LRBT")

              pdf.set_auto_page_break(false)

          end

table.issues td.description, table.issues td.last_notes {color:#777; font-size:90%; padding:4px 4px 4px 24px; text-align:left; white-space:normal;}

table.issues td.description pre, table.issues td.last_notes pre {white-space:normal;}

  def test_index_with_last_notes_column

    get :index, :set_filter => 1, :c => %w(subject last_notes)

    assert_response :success

    assert_select 'table.issues thead th', 3 # columns: chekbox + id + subject

    assert_select 'td.last_notes[colspan="3"]', :text => 'Some notes with Redmine links: #2, r2.'

    assert_select 'td.last_notes[colspan="3"]', :text => 'A comment with inline image:  and a reference to #1 and r2.'

    get :index, :set_filter => 1, :c => %w(subject last_notes), :format => 'pdf'

    assert_response :success

    assert_equal 'application/pdf', response.content_type

  end

  def test_index_with_last_notes_column_should_display_private_notes_with_permission_only

    journal = Journal.create!(:journalized => Issue.find(2), :notes => 'Privates notes', :private_notes => true, :user_id => 1)

    @request.session[:user_id] = 2

    get :index, :set_filter => 1, :c => %w(subject last_notes)

    assert_response :success

    assert_select 'td.last_notes[colspan="3"]', :text => 'Privates notes'

    Role.find(1).remove_permission! :view_private_notes

    get :index, :set_filter => 1, :c => %w(subject last_notes)

    assert_response :success

    assert_select 'td.last_notes[colspan="3"]', :text => 'A comment with inline image:  and a reference to #1 and r2.'

  end

  def test_index_with_description_and_last_notes_columns_should_display_column_name

    get :index, :set_filter => 1, :c => %w(subject last_notes description)

    assert_response :success

    assert_select 'td.last_notes[colspan="3"] span', :text => 'Last notes'

    assert_select 'td.description[colspan="3"] span', :text => 'Description'

  end

    q.column_names = ['subject', 'description', 'tracker', 'last_notes']

    assert_equal [:description, :last_notes], q.block_columns.map(&:name)

  def test_query_should_preload_last_notes

    q = IssueQuery.new(:name => '_', :column_names => [:subject, :last_notes])

    assert q.has_column?(:last_notes)

    issues = q.issues

    assert_not_nil issues.first.instance_variable_get("@last_notes")

  end