diff --git a/app/controllers/settings_controller.rb b/app/controllers/settings_controller.rb
index 3f48d1f..586c239 100644
--- a/app/controllers/settings_controller.rb
+++ b/app/controllers/settings_controller.rb
@@ -19,6 +19,8 @@ class SettingsController < ApplicationController
layout 'admin'
menu_item :plugins, :only => :plugin
+ helper :queries
+
before_filter :require_admin
def index
diff --git a/app/helpers/queries_helper.rb b/app/helpers/queries_helper.rb
index 2001a59..77fe4c2 100644
--- a/app/helpers/queries_helper.rb
+++ b/app/helpers/queries_helper.rb
@@ -37,6 +37,14 @@ module QueriesHelper
tags
end
+ def query_available_inline_columns_options(query)
+ (query.available_inline_columns - query.columns).reject(&:frozen?).collect {|column| [column.caption, column.name]}
+ end
+
+ def query_selected_inline_columns_options(query)
+ (query.inline_columns & query.available_inline_columns).reject(&:frozen?).collect {|column| [column.caption, column.name]}
+ end
+
def column_header(column)
column.sortable ? sort_header_tag(column.name.to_s, :caption => column.caption,
:default_order => column.default_order) :
diff --git a/app/views/queries/_columns.html.erb b/app/views/queries/_columns.html.erb
index 329ffd6..f359c16 100644
--- a/app/views/queries/_columns.html.erb
+++ b/app/views/queries/_columns.html.erb
@@ -4,7 +4,7 @@
<%= label_tag "available_columns", l(:description_available_columns) %>
<%= select_tag 'available_columns',
- options_for_select((query.available_inline_columns - query.columns).reject(&:frozen?).collect {|column| [column.caption, column.name]}),
+ options_for_select(query_available_inline_columns_options(query)),
:multiple => true, :size => 10, :style => "width:150px",
:ondblclick => "moveOptions(this.form.available_columns, this.form.selected_columns);" %>
@@ -18,7 +18,7 @@
<%= label_tag "selected_columns", l(:description_selected_columns) %>
<%= select_tag((defined?(tag_name) ? tag_name : 'c[]'),
- options_for_select((query.inline_columns & query.available_inline_columns).reject(&:frozen?).collect {|column| [column.caption, column.name]}),
+ options_for_select(query_selected_inline_columns_options(query)),
:id => 'selected_columns', :multiple => true, :size => 10, :style => "width:150px",
:ondblclick => "moveOptions(this.form.selected_columns, this.form.available_columns);") %>