Skip to content

Instantly share code, notes, and snippets.

@michaelminter

michaelminter/not_in.rb

Created October 18, 2012 02:35
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save michaelminter/3909556 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save michaelminter/3909556 to your computer and use it in GitHub Desktop.
Download ZIP
Find an array of objects by whats NOT available
Raw
not_in.rb
scope :not_in_user_locations, lambda { |user| { :conditions => ['locations.id NOT IN (SELECT locations.id FROM locations JOIN user_locations ON user_locations.location_id = locations.id WHERE user_locations.user_id = ?)', user.id] }}
Raw
not_in.sql
SELECT * FROM locations
WHERE locations.id NOT IN (
SELECT locations.id FROM locations
JOIN user_locations ON user_locations.location_id = locations.id
WHERE user_locations.user_id = 3);
@michaelminter
Copy link
Copy Markdown
Author

michaelminter commented Oct 18, 2012

3, is the variable

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment