Recommendation for searching with regards to timestamp & foreign key attributes

Sorry guys, please replace "
new_blog_entries = Blog.status_name_does_not_equal_any(['published',
'archived'])
"

with "
new_blog_entries = Blog.status_name_does_not_equal_all(['published',
'archived'])
"

If you are using Rails 2.1 or greater, then named_scope would be very useful.

In your Blog model for example, you can specify a recent named_scope
to return all entries less than 24 hours old.

named_scope :recent, :conditions => [ "created_at > ?", Time.now - 24.hours ]

and maybe another one for unpublished entries

# modify the conditions and include accordingly as I don't know enough about
# your models
named_scope :unpublished, :include => :status, :conditions =>
"statuses.status != 'published'"

In your controllers then, you can do something like

@new_unpublished_entries = Blog.unpublished.recent

bravo! I like the idea, Franz! Thank you :slight_smile: