Patch files for Chatwoot -- https://github.com/orgs/chatwoot/discussions/10668

README.md

Patch files for Chatwoot

• sort_by_created_at_desc.diff: sort by created_at_asc instead of last_activity_at_desc. See https://github.com/orgs/chatwoot/discussions/10668
• search_in_email_subjects.diff: make the search engine work with email subjects

search_in_email_subjects.diff

diff --git app/services/search_service.rb app/services/search_service.rb
index add7938a0..f2b87591a 100644
--- app/services/search_service.rb
+++ app/services/search_service.rb
@@ -27,8 +27,13 @@ class SearchService
   def filter_conversations
     @conversations = current_account.conversations.where(inbox_id: accessable_inbox_ids)
                                     .joins('INNER JOIN contacts ON conversations.contact_id = contacts.id')
-                                    .where("cast(conversations.display_id as text) ILIKE :search OR contacts.name ILIKE :search OR contacts.email
-                            ILIKE :search OR contacts.phone_number ILIKE :search OR contacts.identifier ILIKE :search", search: "%#{search_query}%")
+                                    .where("cast(conversations.display_id as text) ILIKE :search
+                                            OR contacts.name ILIKE :search
+                                            OR contacts.email ILIKE :search
+                                            OR contacts.phone_number ILIKE :search
+                                            OR contacts.identifier ILIKE :search
+                                            OR conversations.additional_attributes->>'mail_subject' ILIKE :search",
+                                           search: "%#{search_query}%")
                                     .order('conversations.created_at DESC')
                                     .limit(10)
   end

sort_by_created_at_desc.diff

diff --git app/javascript/dashboard/components/ChatList.vue app/javascript/dashboard/components/ChatList.vue
index 0438d24af..0548f24d3 100644
--- app/javascript/dashboard/components/ChatList.vue
+++ app/javascript/dashboard/components/ChatList.vue
@@ -87,7 +87,7 @@ const conversationDynamicScroller = ref(null);
 
 const activeAssigneeTab = ref(wootConstants.ASSIGNEE_TYPE.ME);
 const activeStatus = ref(wootConstants.STATUS_TYPE.OPEN);
-const activeSortBy = ref(wootConstants.SORT_BY_TYPE.LAST_ACTIVITY_AT_DESC);
+const activeSortBy = ref(wootConstants.SORT_BY_TYPE.CREATED_AT_ASC);
 const showAdvancedFilters = ref(false);
 // chatsOnView is to store the chats that are currently visible on the screen,
 // which mirrors the conversationList.