Find all records which have a count of an association greater than zero

by

1) To get Projects with at least 1 vacancy:

Project.joins(:vacancies).group('projects.id')

2) To get Projects with more than 1 vacancy:

Project.joins(:vacancies).group('projects.id').having('count(project_id) > 1')

3) Or, if Vacancy model sets counter cache:

belongs_to :project, counter_cache: true

then this will work, too:

Project.where('vacancies_count > ?', 1)

Inflection rule for vacancy may need to be specified manually?

More Related Contents:

  1. How to use ANY instead of IN in a WHERE clause?
  2. ActiveRecord Arel OR condition
  3. Join multiple tables with active records
  4. PostgreSQL where all in array
  5. Rails 4 LIKE query – ActiveRecord adds quotes
  6. Rails find record with zero has_many records associated [duplicate]
  7. Prepared Statement on Postgresql in Rails
  8. ActiveRecord find_each combined with limit and order
  9. Eager load polymorphic
  10. MySQL not using indexes with WHERE IN clause?
  11. Rails 3 ActiveRecord: Order by count on association
  12. Rails order by results count of has_many association
  13. How to chain scope queries with OR instead of AND?
  14. Rails 3: Get Random Record
  15. Best way to count rows by arbitrary time intervals
  16. Disable Rails SQL logging in console
  17. Setting session timeout in Rails 3
  18. Alias for column names in Rails
  19. Rails 3 devise, current_user is not accessible in a Model ?
  20. LEFT OUTER JOIN in Rails 4
  21. Rails 3, has_one / has_many with lambda condition
  22. Rails 3 – select with Include?
  23. belongs_to through associations
  24. Check if record exists from controller in Rails
  25. Validate uniqueness of multiple columns
  26. Rails – Validate Presence Of Association?
  27. Find duplicate rows with PostgreSQL
  28. PGError: ERROR: aggregates not allowed in WHERE clause on a AR query of an object and its has_many objects
  29. Specifying column name in a “references” migration
  30. Rails: Order with nulls last

Leave a Comment