Redmine

                           "due_date" => { :type => :date, :order => 12 },

                           "estimated_hours" => { :type => :integer, :order => 13 },

                           "done_ratio" =>  { :type => :integer, :order => 14 }}

    user_values = []

    user_values << ["<< #{l(:label_me)} >>", "me"] if User.current.logged?

    if project

    end

    @available_filters["assigned_to_id"] = { :type => :list_optional, :order => 4, :values => user_values } unless user_values.empty?

    @available_filters["author_id"] = { :type => :list, :order => 5, :values => user_values } unless user_values.empty?

    if User.current.logged?

      @available_filters["watcher_id"] = { :type => :list, :order => 15, :values => [["<< #{l(:label_me)} >>", "me"]] }

    end

      operator = operator_for(field)

      # "me" value subsitution

        v.push(User.current.logged? ? User.current.id.to_s : "0") if v.delete("me")

      end

        db_field = 'value'

        is_custom_filter = true

        sql << "#{Issue.table_name}.id IN (SELECT #{Issue.table_name}.id FROM #{Issue.table_name} LEFT OUTER JOIN #{db_table} ON #{db_table}.customized_type='Issue' AND #{db_table}.customized_id=#{Issue.table_name}.id AND #{db_table}.custom_field_id=#{$1} WHERE "

      elsif field == 'watcher_id'

        db_table = Watcher.table_name

        db_field = 'user_id'

        sql << "#{Issue.table_name}.id #{ operator == '=' ? 'IN' : 'NOT IN' } (SELECT #{db_table}.watchable_id FROM #{db_table} WHERE #{db_table}.watchable_type='Issue' AND "

        sql << sql_for_field(field, '=', v, db_table, db_field) + ')'

      else

        # regular field

        db_table = Issue.table_name

  private

  # Helper method to generate the WHERE sql for a +field+, +operator+ and a +value+

    sql = ''

    case operator

    when "="

      sql = "#{db_table}.#{db_field} IN (" + value.collect{|val| "'#{connection.quote_string(val)}'"}.join(",") + ")"

    when "!"

      sql = "(#{db_table}.#{db_field} IS NULL OR #{db_table}.#{db_field} NOT IN (" + value.collect{|val| "'#{connection.quote_string(val)}'"}.join(",") + "))"

    when "!*"

  field_description: Description

  field_summary: Summary

  field_is_required: Required

  field_firstname: Firstname

  field_lastname: Lastname

  field_mail: Email