mongoid, query with element in array

Question

I have structure class like this:

#<Transaction _id: 54d46d6a6e6f626fbcc70000,  _keywords: ["1", "test1", "test2", "abc1", "projectmongo", "last2", "taka"]>

array keyword map with: [field1, field2,...] So I want to query to get all transaction have field1 == "1" Is this possible?

Do you mean fetching all Transaction records, where only first element in _keywords array == "1"? — Paweł Dawczak
– Paweł Dawczak, Commented Mar 3, 2015 at 9:23
fetching All, and merge with other filters. Like it: Transaction.where(:company=> params[:company]).where(:_keywords.0 => "1") — Peter89
– Peter89, Commented Mar 3, 2015 at 10:33

Neil Lunn · Accepted Answer · 2015-03-03 09:34:38Z

2

MongoDB "dot notation". Don't expect there to be a "rails like" SQL ORM mapping equivalent when using functionality like arrays which are generally not supported for those storage engines:

Class.collection.find({ "_keywords.0" => "1" })

So the Moped syntax here is more raw to the MongoDB functionality.

That basically says "look at the first array element to see if it matches the value I ask for".

answered Mar 3, 2015 at 9:34

Neil Lunn

151k36 gold badges356 silver badges327 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Peter89 Over a year ago

I use "where" to query. Beacause it have many ohter filters. Can you write it in rails mongoid syntax, please ?

Neil Lunn Over a year ago

@Peter_175 The very point I made is that there "is no Rails Syntax" for this because there is nothing that correlates to SQL Datastores in what you are asking. It works. If you expect it to work across different storage engines then you have a how different problem to solve.

Peter89 Over a year ago

Yep. So I must convert "where" syntax to collection.find. Thanks @Neil :)

Collectives™ on Stack Overflow

mongoid, query with element in array

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related