redmine.tokyo » Unofficial Redmine Cooking

コード追っかけてみた。

カスタムクエリのサイドバー表示については、下記変更すれば対応できるんじゃないかな。
・self.visible(*args)
・global_or_on_project呼び出し部分

カスタムクエリのサイドバー表示部分¶

helpers/queries_helper.rb

# Returns the queries that are rendered in the sidebar
  def sidebar_queries(klass, project)
    klass.visible.global_or_on_project(@project).sorted.to_a
  end

# Renders a group of queries
  def query_links(title, queries)
    return '' if queries.empty?
    # links to #index on issues/show

    content_tag('h3', title) + "\n" +
      content_tag('ul',
        queries.collect {|query|
            css = 'query'
            css << ' selected' if query == @query
            content_tag('li', link_to(query.name, url_params.merge(:query_id => query), :class => css))
          }.join("\n").html_safe,
        :class => 'queries'
      ) + "\n" 
  end

# Renders the list of queries for the sidebar
  def render_sidebar_queries(klass, project)
    queries = sidebar_queries(klass, project)
    out = ''.html_safe
    out << query_links(l(:label_my_queries), queries.select(&:is_private?))
    out << query_links(l(:label_query_plural), queries.reject(&:is_private?))
    out
  end
end

models/query.rb

class Query < ActiveRecord::Base
....
  # Scope of queries that are global or on the given project
  scope :global_or_on_project, lambda {|project|
    where(:project_id => (project.nil? ? nil : [nil, project.id]))
  }

def self.visible(*args)
..
    scope = joins("LEFT OUTER JOIN #{Project.table_name} ON #{table_name}.project_id = #{Project.table_name}.id").
      where("#{table_name}.project_id IS NULL OR (#{base})")
..

# Returns true if the query is visible to +user+ or the current user.
def visible?(user=User.current)
..

プロジェクトの指定したメンバー/ロール割当ユーザ間でカスタムクエリを共用するプラグイン
all projectsでロールによるアクセス制御を行えば、admin作業無しで運用対処もできそう。

Redmine "Custom Query Share" Plugin
https://github.com/jrupesh/redmine_query_share

The Plugins aims at providing some user specific customization in redmine.

Custom Query can be Private, Shared with users with specific Roles or Public,
The plugin provide another option "to selected users",
This allows selections of Project member users and groups and the query will be accessible only for these members.