To help myself learn ruby and rails, I am implementing a todo list manager. Every task can have sub tasks (and so on.) I am using betternestedset Until this point, I have been getting everything and then only displaying if it is not done OR it has been updated in the last day. (If you don''t display a parent, you don''t display any of its children.) However, it seems to me that this should be done in the getting of data instead of the displaying of it. I can do this for the root trees: <code> one_day_old = Date.today - 1 find(:all, :conditions => "(user_id = #{user.id}) AND ((done = ''f'') OR (updated_at >''#{one_day_old}'')) AND ((parent_id IS NULL) OR (parent_id 0))", :order => "lft") </code> However, then when I query the children I still get ones that I don''t want to show. It looks like full_set with the exclude string may be the right way to go, but I can''t quite figure it out. (Or if there is a more "rails-y" way to go about this....) Any suggestions? --Alan --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---