Activerecord where array with less than condition

Question

I have an array of conditions i'm passing to where(), with the conditions being added one at a time such as

conditions[:key] = values[:key]
...
search = ModelName.where(conditions)

which works fine for all those that i want to compare with '=', however I want to add a '<=' condition to the array instead of '=' such as

conditions[:key <=] = values[:key]

which of course won't work. Is there a way to make this work so it i can combine '=' clauses with '<=' clauses in the same condition array?

Hash notation in ActiveRecord Queries

souslov
– souslov

2015-08-14 20:44:56 +00:00
Commented Aug 14, 2015 at 20:44 — souslov
– souslov, Commented Aug 14, 2015 at 20:44
Also, take a look at Arel, maybe helpful.

souslov
– souslov

2015-08-14 20:50:15 +00:00
Commented Aug 14, 2015 at 20:50 — souslov
– souslov, Commented Aug 14, 2015 at 20:50

K M Rakibul Islam · Accepted Answer · 2015-08-14 22:09:04Z

1

One way of doing it:

You could use <= in a where clause like this:

   User.where('`users`.`age` <= ?', 20)

This will generate the following SQL:

SELECT `users`.* FROM `users` WHERE (`users`.`age` <= 20)

Update_1:

For multiple conditions, you could do this:

User.where('`users`.`age` <= ?', 20).where('`users`.`name` = ?', 'Rakib')

Update_2:

Here is another way for multiple conditions in where clause:

User.where('(id >= ?) AND (name= ?)', 1, 'Rakib')

You can add any amount of AND OR conditions like this in your ActiveRecord where clause. I just showed with 2 to keep it simple.

See Ruby on Rails Official Documentation for Array Conditions for more information.

Update_3:

Another slight variation of how to use Array Conditions in where clause:

conditions_array = ["(id >= ?) AND (name = ?)", 1, "Rakib"]
User.where(conditions_array)

I think, this one will fit your exact requirement.

edited Aug 14, 2015 at 22:09

answered Aug 14, 2015 at 20:59

K M Rakibul Islam

34.4k13 gold badges95 silver badges113 bronze badges

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

3 Comments

xd6_ Over a year ago

What I keep getting when i try to do this is WHERE "users.age <= 20" so it's inserting double quotes around the whole clause. I think the issue is i have several clauses stored in an array, which is being passed to where() instead of passing a single string with the value as the second param.

K M Rakibul Islam Over a year ago

@xd6_ See my updated answer. You can easily chain your where clauses for multiple conditions like above. Let me know if you have any other question.

K M Rakibul Islam Over a year ago

@xd6_ Please look at my Update_3, I think this will work for you. Let me know if not!

ReggieB · Accepted Answer · 2015-08-14 22:21:41Z

1

You could use arel.

conditions = {x: [:eq, 1], y: [:gt, 2]}

model_names = ModelName.where(nil)

conditions.each do |field, options|
  condition = ModelName.arel_table[field].send(*options)
  model_names = model_names.where(condition)
end

model_names.to_sql --> 'SELECT * FROM model_names WHERE x = 1 and y > 2'

edited Aug 14, 2015 at 22:21

answered Aug 14, 2015 at 22:12

ReggieB

8,2673 gold badges43 silver badges48 bronze badges

Collectives™ on Stack Overflow

Activerecord where array with less than condition

2 Answers 2

Update_1:

Update_2:

Update_3:

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Update_1:

Update_2:

Update_3:

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related