Active Record Query where value in array field

Question

I have a table called " Stat " in my MongoDB database in Rails 3 .

In that table, there is an array field called "services" .

I want to find all Stats that have a services array that contains the value "lights" .

I want to do something like this :

@stats = Stat.all
@stats1 =  @stats.where("services contains lights")
Rails.logger.info "result:  #{@stats1.count}  "

I've tried various things and Googled it extensively, found some leads but nothing that seems to work. I have four records that should match this query but the above returns a zero set.

Is what I want to do possible in rails 3 / mongo ?

What Object Mapper are you using to access MongoDB? If you are using the native Ruby driver it does not implement ActiveRecord; you would instead be doing a find() on a collection. — Stennie
– Stennie, Commented Aug 11, 2012 at 2:37

Elmiya Agnes · Accepted Answer · 2017-08-04 08:58:52Z

4

Try this,

@stats = Stat.all

@stats1 =  @stats.where("'lights' = ANY (services)")

answered Aug 4, 2017 at 8:58

Elmiya Agnes

2432 silver badges11 bronze badges

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

Comments

Konstantin Shilov · Accepted Answer · 2020-11-16 11:28:12Z

1

Ok I found the answer to this question:

@stats =  @stats.where(:services.in =>['lights'] )

and I also found by poking around that the inverse is:

@stats =  @stats.where(:services.nin =>['lights'] )

nin instead of in

edited Nov 16, 2020 at 11:28

Konstantin Shilov

13.3k17 gold badges83 silver badges78 bronze badges

answered Oct 11, 2012 at 20:14

Nmuta

3444 silver badges15 bronze badges

2 Comments

Hovis Biddle Over a year ago

I understand this is old, but maybe you could link to where you found your answer?

Nmuta Over a year ago

I actually think I got the answer to this by asking one of my co-workers at the time, and then fiddling with it to find the "nin" variation.

Collectives™ on Stack Overflow

Active Record Query where value in array field

2 Answers 2

Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related