SyntaxFix

[ruby-on-rails] ActiveRecord find and only return selected columns

pluck(column_name)

This method is designed to perform select by a single column as direct SQL query Returns Array with values of the specified column name The values has same data type as column.

Examples:

Person.pluck(:id) # SELECT people.id FROM people
Person.uniq.pluck(:role) # SELECT DISTINCT role FROM people
Person.where(:confirmed => true).limit(5).pluck(:id)

see http://api.rubyonrails.org/classes/ActiveRecord/Calculations.html#method-i-pluck

Its introduced rails 3.2 onwards and accepts only single column. In rails 4, it accepts multiple columns

Examples related to ruby-on-rails

• Embed ruby within URL : Middleman Blog • Titlecase all entries into a form_for text field • Where do I put a single filter that filters methods in two controllers in Rails • Empty brackets '[]' appearing when using .where • How to integrate Dart into a Rails app • Rails 2.3.4 Persisting Model on Validation Failure • How to fix "Your Ruby version is 2.3.0, but your Gemfile specified 2.2.5" while server starting • Is the server running on host "localhost" (::1) and accepting TCP/IP connections on port 5432? • Rails: Can't verify CSRF token authenticity when making a POST request • Uncaught ReferenceError: React is not defined

Examples related to ruby-on-rails-3

• Is the server running on host "localhost" (::1) and accepting TCP/IP connections on port 5432? • rake assets:precompile RAILS_ENV=production not working as required • How do you manually execute SQL commands in Ruby On Rails using NuoDB • Check if record exists from controller in Rails • How to restart a rails server on Heroku? • How to have a drop down <select> field in a rails form? • "Uncaught TypeError: undefined is not a function" - Beginner Backbone.js Application • Adding a simple spacer to twitter bootstrap • How can I change cols of textarea in twitter-bootstrap? • Rails: FATAL - Peer authentication failed for user (PG::Error)

Examples related to rails-activerecord

• Rails 2.3.4 Persisting Model on Validation Failure • Add a reference column migration in Rails 4 • Rails 4: List of available datatypes • ActiveModel::ForbiddenAttributesError when creating new user • find vs find_by vs where • Combine two ActiveRecord::Relation objects • Float vs Decimal in ActiveRecord • ActiveRecord find and only return selected columns • Rails update_attributes without save? • How to change default timezone for Active Record in Rails?