query , can not select column count

by

Have you tried calling the count method on one of the returned Tag objects? Just because inspect doesn’t mention the count doesn’t mean that it isn’t there. The inspect output:

[#<Tag id: 401, name: "different">, ... , #<Tag id: 4, name: "family">]

will only include things that the Tag class knows about and Tag will only know about the columns in the tags table: you only have id and name in the table so that’s all you see.

If you do this:

tags = Tag.joins(:quote_tags).group('quote_tags.tag_id').order('count desc').select('count(tags.id) AS count, tags.id, tags.name')

and then look at the counts:

tags.map(&:count)

You’ll see the array of counts that you’re expecting.

More Related Contents:

  1. Rails 5: ActiveRecord OR query
  2. Rails ActiveRecord methods in different places [closed]
  3. How to change default timezone for Active Record in Rails?
  4. Rails :include vs. :joins
  5. ActiveRecord: size vs count
  6. Connecting Rails 3.1 with Multiple Databases
  7. Rails model without database
  8. How do I replace accented Latin characters in Ruby?
  9. ActiveRecord OR query Hash notation
  10. How to chain scope queries with OR instead of AND?
  11. Using Rails serialize to save hash to database
  12. Rails 3: Get Random Record
  13. How to handle Ruby on Rails error: “Please install the postgresql adapter: `gem install activerecord-postgresql-adapter'”
  14. Clean way to find ActiveRecord objects by id in the order specified
  15. Altering the primary key in Rails to be a string
  16. ActiveRecord Find By Year, Day or Month on a Date field
  17. LEFT OUTER joins in Rails 3
  18. How to test for (ActiveRecord) object equality
  19. How do i work with two different databases in rails with active records?
  20. Rails ActiveRecord: Find All Users Except Current User
  21. How to use ActiveRecord in a ruby script outside Rails?
  22. Creating a PostgreSQL sequence to a field (which is not the ID of the record)
  23. Can I write PostgreSQL functions on Ruby on Rails?
  24. Regular expressions with validations in RoR 4
  25. What are the brackets [5.1] after ActiveRecord Migration and how does it work? [duplicate]
  26. Rails 3.1 limit user created objects
  27. Store the day of the week and time?
  28. What is the difference between pluck and collect in Rails?
  29. Is there a way to avoid automatically updating Rails timestamp fields?
  30. Rails: Overriding ActiveRecord association method

Leave a Comment