For array of ActiveRecord objects, return array of their attributes

Question

@matched = [1, 2, 3]

Where each integer represents the id of an ActiveRecord object in the Inventory class. As a next step, I want to look at each of those objects and obtain the email of the parent User, but I'm not sure how to do it. Ideally I'd write something like:

Inventory.where(id: @matched).user.email

Because certainly, this statement would work if I only had a single id to look up. Since that doesn't work, I'm instead doing this

@email = []
@matched.each do |i|
   @email << Inventory.find_by_id(i).user.email
end

Just wondering if there's an easier way.

Thanks!

Arctodus · Accepted Answer · 2014-07-05 18:07:03Z

2

If you only need the email addresses then you can use the pluck method:

Inventory.where(id: @matched).joins(:user).pluck("users.email")

answered Jul 5, 2014 at 18:07

Arctodus

5,8473 gold badges34 silver badges45 bronze badges

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

2 Comments

boulder_ruby Over a year ago

This is way better than my answer. I'm such a hacker I swear

mus Over a year ago

I was going to post an answer with Array#map but this is the best solution.

boulder_ruby · Accepted Answer · 2014-07-05 18:08:01Z

0

class Inventory

  def self.with_ids(ids) 
    sql = @matched.map{|id| "id = #{id}"}.join(" OR ")
    where(sql)
  end

  def parent_email
    user.email
  end
 end

Inventory.with_ids(@matched).map(&:parent_email)

answered Jul 5, 2014 at 18:08

boulder_ruby

40k9 gold badges82 silver badges104 bronze badges

Collectives™ on Stack Overflow

For array of ActiveRecord objects, return array of their attributes

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related