How i can write a query inside select in rails

ruby-on-rails ruby ruby-on-rails-3 activerecord activemodel
kashif picture kashif · Sep 9, 2013 · Viewed 11.8k times · Source

How can I write this query in Ruby on Rails? Query inside a select

SELECT id, 
       company_id, 
       (SELECT name 
        FROM   companies 
        WHERE  id = referred_to_id) AS name 
FROM   referrals 
WHERE  company_id = 21

Answer

Dan Grahn picture Dan Grahn · Sep 9, 2013

In Rails you don't really need to worry about writing SQL like this. ActiveRecord handles the creation of all your simple SQL commands.

The code below will give you the company name so long as you have set up your relationships correctly in the models.

@referral = Referral.find(21)
@referral.company.name

See this tutorial on Active Record Associations

Related questions

Rails 3: Get Random Record

So, I've found several examples for finding a random record in Rails 2 -- the preferred method seems to be: Thing.find :first, :offset => rand(Thing.count) Being something of a newbie I'm not sure how this could be constructed …

Read More
validation custom message for rails 3

Rails has introduced new way to validate attributes inside model. When I use validates :title, :presence => true it works but when I try to add a custom message validates :title, :presence => true,:message => "Story title is required" …

Read More
find() with nil when there are no records

In my current rails program when I use something like user = User.find(10) When there is no user with ID=10 , I will have exception like : ActiveRecord::RecordNotFound: Couldn't find User with ID=10 Can I get nil instead of raising exception …

Read More