Hi,
I have problem with my named scopes.
A membership has many property_details through join_property_details. I do an anonymous named_scope to get all memberships hat have 'ns' and 'ae' as property_details. However I get always an empty search result.
scope = scope.scoped( :conditions => ['property_details.short = ?', 'ns'], :include => :property_details ) scope = scope.scoped( :conditions => ['property_details.short = ?', 'ae'], :include => :property_details )
SELECT DISTINCT `memberships`.id FROM `memberships` LEFT OUTER JOIN `join_property_details` ON (`memberships`.`id` = `join_property_details`.`membership_id`) LEFT OUTER JOIN `property_details` ON (`property_details`.`id` = `join_property_details`.`property_detail_id`) WHERE (property_details.short = 'ae') AND (property_details.short = 'ns')
What do I have to do to get all memberships that have 'ns' and 'ae' as property_details?
Thanks in advance