Reported by Chris

Title doesn't really help, but I couldn't think of a better one with the time I had.

Scenario: Given models Products and Categories with a habtm relationship between them and a visible attribute on a Category and Products.

As an admin, I need to prevent users from viewing products that have at least one hidden category when listing all products. Since there is a many to many relationship between categories and products, I need to ensure that my all products list does not contain any products with an associated category that has visible = false.

Issue: Right now using the following syntax with Squirel will not work as expected Product.rb self.find_visible find :all do categories.visible = false categories.id.nil? end

The only way I can think to do this is with a subquery, and Squirrel doesn't seem to handle those. Although this normally wouldn't be a problem, the documentation for Squirrel implies that the id.nil? function could work with any relationship.