summaryrefslogtreecommitdiffstats
path: root/app/models
diff options
context:
space:
mode:
Diffstat (limited to 'app/models')
-rw-r--r--app/models/version.rb4
1 files changed, 3 insertions, 1 deletions
diff --git a/app/models/version.rb b/app/models/version.rb
index bb0e7ec42..0ea1c3c71 100644
--- a/app/models/version.rb
+++ b/app/models/version.rb
@@ -186,9 +186,11 @@ class Version < ActiveRecord::Base
def self.fields_for_order_statement(table=nil)
table ||= table_name
- %w(effective_date name).map {|field| "#{table}.#{field}"}
+ ["(CASE WHEN #{table}.effective_date IS NULL THEN 1 ELSE 0 END)", "#{table}.effective_date", "#{table}.name", "#{table}.id"]
end
+ scope :sorted, order(fields_for_order_statement)
+
# Returns the sharings that +user+ can set the version to
def allowed_sharings(user = User.current)
VERSION_SHARINGS.select do |s|