Defect #36059

Fulltext search in timelog comments

Added by Jan K. 11 months ago. Updated 7 months ago.

Status:NewStart date:
Priority:NormalDue date:
Assignee:-% Done:


Category:Search engine
Target version:Candidate for next major release
Resolution: Affected version:


The Redmine Fulltext search is a great feature. We use it all the time.

Unfortunately it does not search in the Comments of the Timelogs.

Is there any chynce to add this datasource to the fulltext search?

add-spent-time-to-search.png (58.3 KB) Yuichi HARADA, 2022-02-10 02:40

36059.patch Magnifier (2.68 KB) Yuichi HARADA, 2022-02-10 02:42


#1 Updated by Yuichi HARADA 8 months ago

I fixed it so that comments on spent time can be searched. I have attached a patch.

diff --git a/app/models/time_entry.rb b/app/models/time_entry.rb
index 88e1796f34..5422e3f273 100644
--- a/app/models/time_entry.rb
+++ b/app/models/time_entry.rb
@@ -28,6 +28,8 @@ class TimeEntry < ActiveRecord::Base
   belongs_to :activity, :class_name => 'TimeEntryActivity'

+  acts_as_searchable :columns => ['comments'],
+                     :preload => [:project, :issue]
     :title => do |o|
diff --git a/lib/redmine/preparation.rb b/lib/redmine/preparation.rb
index 4c6b3afe6e..08b6c33fd9 100644
--- a/lib/redmine/preparation.rb
+++ b/lib/redmine/preparation.rb
@@ -383,6 +383,7 @@ module Redmine do |search|
         search.register :issues
+        search.register :time_entries
         search.register :news
         search.register :documents
         search.register :changesets

#2 Updated by Go MAEDA 7 months ago

  • Target version set to Candidate for next major release

Also available in: Atom PDF