jro_apps/redmine Commit - r10886:9a66463ff846

Prevent sqlserver adapter from breaking the sub-query (#12713)....

Jean-Philippe Lang -

r10886:9a66463ff846

parent child

Context file:

r10886:9a66463ff846

app/models/issue_query.rb +1 -1

                    index = (index ? index + 1 : -1)
                    # insert the column after estimated_hours or at the end
                    @available_columns.insert index, QueryColumn.new(:spent_hours,
-                     :sortable => "(SELECT COALESCE(SUM(hours), 0) FROM #{TimeEntry.table_name} WHERE #{TimeEntry.table_name}.issue_id = #{Issue.table_name}.id)",
+                     :sortable => "COALESCE((SELECT SUM(hours) FROM #{TimeEntry.table_name} WHERE #{TimeEntry.table_name}.issue_id = #{Issue.table_name}.id), 0)",
                      :default_order => 'desc',
                      :caption => :label_spent_time
                    )

General Comments 0

You need to be logged in to leave comments. Login now

No TODOs yet

	Repositories
g s	Goto summary page
g c	Goto changelog page
g f	Goto files page
g F	Goto files page with file search activated
g p	Goto pull requests page
g o	Goto repository settings
g O	Goto repository access permissions settings
t s	Toggle sidebar on some pages