Rails: Use a variable as a hash key

Question

I've been trying to do this for the past 10 hours, but it's been useless.

For example:

Event.where(login_screen: Time.now-8.days ..Time.now)

I have an Event table and login_screen is one of the column names. I'm listing them in a drop-down menu and I'd like to take the event names as a variable. It's in the request params like this: params[:segmentation][:first_event]. When I tried to give it like:

Event.where(params[:segmentation][:first_event] Time.now-8.days ..Time.now)

...it didn't work. I tried to use to_sym but that didn't help either.

How can I use a variable as a symbol?

Another question:

What's the difference between :hello and hello: ?

mikdiet · Accepted Answer · 2014-08-22 13:43:28Z

3

It's alternative syntax for ruby hashes with symbols as keys

Event.where(login_screen: Time.now-8.days ..Time.now)

is the same as

Event.where(:login_screen => Time.now-8.days ..Time.now)

So, if you store key in variable you need use 'hash rocket' syntax:

Event.where(params[:segmentation][:first_event] => Time.now-8.days ..Time.now)

answered Aug 22, 2014 at 13:43

mikdiet

10.1k8 gold badges62 silver badges71 bronze badges

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

Comments

Milind · Accepted Answer · 2014-08-22 14:12:55Z

0

these are the different ways to pass arguments in where clause:--

User.where(["name = ? and email = ?", "Joe", "[email protected]"])

User.where(["name = :name and email = :email", { name: "Joe", email: "[email protected]" }])

User.where("name = :name and email = :email", { name: "Joe", email: "[email protected]" })

using hash:-

User.where({ created_at: (Time.now.midnight - 1.day)..Time.now.midnight })

User.where({ name: ["Alice", "Bob"]})

User.where({ name: "Joe", email: "[email protected]" })

answered Aug 22, 2014 at 14:12

Milind

5,1222 gold badges29 silver badges58 bronze badges

Collectives™ on Stack Overflow

Rails: Use a variable as a hash key

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related