Compose an ActiveRecord query having array of string conditions

Question

I have an array of strings that are to serve as params for a where call in a model. How do I append each of the strings in the models where call and return the active record relation for an additional limit call

I have tried the following but it only adds the first item to the where clause

array = ['active = true', 'expired = false', 'created_at > 2017-04-18 10:36:28']
array.reduce { | item | Post.where(item) }

returns

Posts.where('active = true')

whereas am begging for

Posts.where('active = true').where('expired = false').where('created_at > 2017-04-18 10:36:28')

Thanks.

Andrey Deineko · Accepted Answer · 2017-04-28 07:50:23Z

3

Just join array's elements into a single string:

array.join(' AND ')
#=> "active = true AND expired = false AND created_at > 2017-04-18 10:36:28"

And use it:

Post.where(array.join(' AND '))

P.S.

created_at > 2017-04-18 10:36:28 will probably throw you a syntax error, but that's out of the question's scope.

edited Apr 28, 2017 at 7:50

answered Apr 28, 2017 at 7:45

Andrey Deineko

52.5k11 gold badges119 silver badges151 bronze badges

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

2 Comments

Ursus Over a year ago

You mean AND, not ,, otherwise you need an hash

Ursus Over a year ago

Good morning bro ^_^

Collectives™ on Stack Overflow

Compose an ActiveRecord query having array of string conditions

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related