Read more

Collect all values for a given column in an ActiveRecord scope

Avatar
Arne Hartherz
September 13, 2010Software engineer at makandra GmbH

In modern Rails versions you can also use ActiveRecord's pluck Archive method.

>> User.active.pluck(:id)
=> [1, 5, 23, 42]
Illustration online protection

Rails Long Term Support

Rails LTS provides security patches for old versions of Ruby on Rails (2.3, 3.2, 4.2 and 5.2)

  • Prevents you from data breaches and liability risks
  • Upgrade at your own pace
  • Works with modern Rubies
Read more

If you are plucking from the id column in particular you can also say:

>> User.active.ids
=> [1, 5, 23, 42]

For a DISTINCT selection, use distinct on your scope (not the resulting array).

>> Article.distinct.pluck(:state)
# SELECT DISTINCT state FROM articles
=> ['draft', 'published']

In Rails 3 and 4 you must use uniq instead of distinct:

>> Article.uniq.pluck(:state)
# SELECT DISTINCT state FROM articles
=> ['draft', 'published']

Plucking columns in legacy Rails versions

For older Rails versions you can use the collect_column method from Edge Rider Archive for the same purpose as pluck.

Posted by Arne Hartherz to makandra dev (2010-09-13 19:57)