filter values not working for Mongoid.

[dennisfaust]

We are trying to retrieve documents from Mongo using the filters business_id and person_id. With the filter values like this:

http://localhost:3000/api/v1/emails?filter[business_id]=123

Those are then each being converted to an array by CVS.parse_line in Resource#verify_keys like so:

'business_id' => ['123']

ActiveRecord will convert where(business_id: ['123']) to an in clause which is effectively an OR operation. Mongoid (and Mongo), however, will use the array as the value (since Mongo supports arrays as fields). This does not have the same semantics as an in clause in AR. As a result, our filters return no results because obviously we are not storing the business_id as an array.

We looked at tweaking this behavior in the verify_filter method but quickly realized that method is used for other purposes. Many tests broke after we applied the following:

      def verify_filter(filter, raw, context = nil)
        filter_values = case raw
        when String
          parts = CSV.parse_line(raw)
          parts.length > 1 ? parts : raw
        else
          raw
        end

        if is_filter_association?(filter)
          verify_association_filter(filter, filter_values, context)
        else
          verify_custom_filter(filter, filter_values, context)
        end
      end

We'd love to help out with a patch but could use some guidance on how you think this should be handled.

[bvandenbos]

Dup of #118

[dennisfaust]

Here's a hack we're using if you run into this:

  def self.apply_filter(records, filter, value)
    if value.is_a?(Array)
      raise "Not Supported: value contains >1 element: #{value}" if value.length > 1
      value = value.first
    end
    records.where(filter => value)
  end

Obviously, this doesn't work if the filter does contain an array of elements.

[juanibiapina]

Updates on this?

[tommy-russoniello]

Duplicate of #118