From 68149f8c73cf8a791f1d814916abf4b1e1aa47a5 2011-12-04 19:13:09
From: Jean-Philippe Lang <jp_lang@yahoo.fr>
Date: 2011-12-04 19:13:09
Subject: [PATCH] Fixes spent time column sort for postgresql.

git-svn-id: svn+ssh://rubyforge.org/var/svn/redmine/trunk@8077 e93f8b46-1217-0410-a6f0-8f06a7374b81

---

diff --git a/app/models/query.rb b/app/models/query.rb
index f41c1cd..0f14047 100644
--- a/app/models/query.rb
+++ b/app/models/query.rb
@@ -367,7 +367,7 @@ class Query < ActiveRecord::Base
       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 SUM(hours) FROM #{TimeEntry.table_name} WHERE #{TimeEntry.table_name}.issue_id = #{Issue.table_name}.id)",
+        :sortable => "(SELECT COALESCE(SUM(hours), 0) FROM #{TimeEntry.table_name} WHERE #{TimeEntry.table_name}.issue_id = #{Issue.table_name}.id)",
         :default_order => 'desc',
         :caption => :label_spent_time
       )