Redmine

        op = (operator == "!p" ? 'NOT IN' : 'IN')

        comp = (operator == "=!p" ? '<>' : '=')

        "#{Issue.table_name}.id #{op} (SELECT DISTINCT #{IssueRelation.table_name}.#{join_column} FROM #{IssueRelation.table_name}, #{Issue.table_name} relissues WHERE #{IssueRelation.table_name}.relation_type = '#{self.class.connection.quote_string(relation_type)}' AND #{IssueRelation.table_name}.#{target_join_column} = relissues.id AND relissues.project_id #{comp} #{value.first.to_i})"

      end

    if relation_options[:sym] == field && !options[:reverse]

    "!~"  => :label_not_contains,

    "=p"  => :label_any_issues_in_project,

    "=!p" => :label_any_issues_not_in_project,

  }

  class_attribute :operators_by_filter_type

    :text => [  "~", "!~", "!*", "*" ],

    :integer => [ "=", ">=", "<=", "><", "!*", "*" ],

    :float => [ "=", ">=", "<=", "><", "!*", "*" ],

  }

  class_attribute :available_columns

          # filter requires one or more values

          (values_for(field) and !values_for(field).first.blank?) or

          # filter doesn't require any value

    end if filters

  end

  permission_view_private_notes: View private notes

  permission_set_notes_private: Set notes as private

  label_no_issues_in_project: no issues in project

  label_any: all

  label_last_n_weeks: last %{count} weeks

  setting_cross_project_subtasks: Allow cross-project subtasks

  label_any_issues_in_project: any issues in project

  label_any_issues_not_in_project: any issues not in project

  label_no_issues_in_project: no issues in project

  label_day_plural: days

  label_repository: Repository

  label_repository_new: New repository

    case "y":

    case "o":

    case "c":

      enableValues(field, []);

      break;

    case "><":