Rails active record querying association with ‘exists’

by

You can use includes and then test if the related response(s) exists like this:

def surveys_completed
  members.includes(:responses).where('responses.id IS NOT NULL')
end

Here is an alternative, with joins:

def surveys_completed
  members.joins(:responses)
end

The solution using Rails 4:

def surveys_completed
  members.includes(:responses).where.not(responses: { id: nil })
end

Alternative solution using activerecord_where_assoc:
This gem does exactly what is asked here: use EXISTS to to do a condition.
It works with Rails 4.1 to the most recent.

members.where_assoc_exists(:responses)

It can also do much more!

Similar questions:

More Related Contents:

  1. Fully custom validation error message with Rails
  2. Why isn’t my CORS configuration causing the server to filter incoming requests? How can I make the server only accept requests from a specific origin?
  3. How can I disable logging of asset pipeline (sprockets) messages in Ruby on Rails 3.1?
  4. OO Design in Rails: Where to put stuff
  5. What do helper and helper_method do?
  6. How do I set default host for url helpers in rails?
  7. devise and multiple “user” models
  8. Converting camel case to underscore case in ruby
  9. OpenSSL::SSL::SSLError on Heroku [duplicate]
  10. How can I uninstall Ruby on ubuntu?
  11. Overriding id on create in ActiveRecord
  12. How do i work with two different databases in rails with active records?
  13. Connecting to WSL2 server via local network
  14. Using Rails Migration on different database than standard “production” or “development”
  15. Ruby on Rails — multiple selection in f.select
  16. Rails Console: reload! not reflecting changes in model files? What could be possible reason?
  17. How would you parse a url in Ruby to get the main domain?
  18. no such file to load — readline
  19. counter_cache with has_many :through
  20. Rails Routes – Limiting the available formats for a resource
  21. How can I rollback a specific migration?
  22. confusing about autoload_paths vs eager_load_paths in rails 4
  23. SimpleForm without for (non model form)
  24. Rails: How to parse date-time string into a specific time zone
  25. What does binding a Rails Server to 0.0.0.0 buy you?
  26. Why can’t I install the SQLite gem?
  27. Error message: Make sure that `gem install pg -v ‘0.18.1’` succeeds before bundling
  28. Non persistent ActiveRecord model attributes
  29. Rails 4.0 expire_fragment/cache expiration not working
  30. How to skip a before_filter for Devise’s SessionsController?

Leave a Comment