Ruby on Rails: named scope with lamda and an array.

Question

named_scope :all_public, lambda { |users| 
       { :conditions =>  ["visibility = ? || (visibility = ? && user_id = ?)", Shared::PUBLIC, Shared::PRIVATE, users] }
     }

that works nice for one user, but is there a way to modify it to work where users is an array of user ids?

Answer 1

Something like this and then just pass a single element array for the single ID case

named_scope :all_public, lambda { |users| 
       { :conditions =>  ["visibility = ? OR (visibility = ? AND user_id IN (?))", Shared::PUBLIC, Shared::PRIVATE, users.join(',')] }
     }