Redmine

             " WHERE #{IssueRelation.table_name}.relation_type =" \

                  " '#{self.class.connection.quote_string(relation_type)}')"

      when "=", "!"

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

        "#{Issue.table_name}.id #{op}" \

         " (SELECT DISTINCT #{IssueRelation.table_name}.#{join_column}" \

    query.filters = {"relates" => {:operator => '=', :values => ['1,2']}}

    assert_equal [1, 2, 3], find_issues_with_query(query).map(&:id).sort

    query = IssueQuery.new(:name => '_')

    query.filters = {"relates" => {:operator => '!', :values => ['1']}}

    assert_equal Issue.where.not(:id => [2, 3]).order(:id).ids, find_issues_with_query(query).map(&:id).sort