Mongoid not in query

ruby-on-rails ruby mongodb mongoid nosql
Mark Pegasov picture Mark Pegasov · May 9, 2012 · Viewed 14.3k times · Source

I have some trouble with mongoid:

  test "Test candidate" do
    User.create(:id => 1, :sex => User::Male, :country => 1, :city => 1)
    User.create(:id => 2, :sex => User::Female, :country => 1, :city => 1)
    User.create(:id => 3, :sex => User::Female, :country => 1, :city => 1)

    user = User.not_in(:id => [2]).second
    assert_not_equal(user.id, 2)
  end

Test failed. I've tried to use where(:id => {'$nid' => [2]}), but it have same effect.

What is wrong? How to use "not in" condition with mongoid?

PS, "second" is ok, with "first" test passed, because id=1

Answer

Sergio Tulentsev picture Sergio Tulentsev · May 9, 2012

Try this query:

user = User.not_in(:_id => [2]).second

In MongoDB primary key has name _id. Mongoid tries to be friendly and partially hides this fact from the developer by aliasing it to id in the object model. But when you do queries, it cannot tell if you want primary key _id or some completely ordinary field id.

Related questions

Query on Mongoid Hash Field

I want to query on a Hash field for a Mongoid Class. I'm not sure how I can do this with conditions? Here is an example: class Person include Mongoid::Document field :things, :type => Hash end So, let's say …

Read More
How do I validate members of an array field?

I have this model: class Campaign include Mongoid::Document include Mongoid::Timestamps field :name, :type => String field :subdomain, :type => String field :intro, :type => String field :body, :type => String field :emails, :type => Array end Now I …

Read More
How can I get all field names of the Mongoid Document?

I'm building backend system, as written in Iain Hecker's tutorial: http://iain.nl/backends-in-rails-3-1 and I try to adapt it to MongoDB with Mongoid. So when I need to write in backend/resourse_helper.rb module Backend::ResourceHelper def …

Read More