# Recommendation for searching with regards to timestamp & foreign key attributes

**URL:** <https://www.ruby-forum.com/t/recommendation-for-searching-with-regards-to-timestamp-foreign-key-attributes/186466>\
**Category:** Rails\
**Created:** [April 7, 2010, 3:02pm UTC](https://www.ruby-forum.com/t/recommendation-for-searching-with-regards-to-timestamp-foreign-key-attributes/186466 "2010-04-07T15:02:06Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![ct9a](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/ad7895/32.png) [@ct9a](https://www.ruby-forum.com/u/ct9a)\
**Post date:** [April 7, 2010, 3:02pm UTC](https://www.ruby-forum.com/t/recommendation-for-searching-with-regards-to-timestamp-foreign-key-attributes/186466/1 "2010-04-07T15:02:06Z")

</div>

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’])  
"

---

<div class="post-metadata">

**Author:** ![ct9a](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/ad7895/32.png) [@ct9a](https://www.ruby-forum.com/u/ct9a)\
**Post date:** [April 7, 2010, 3:46pm UTC](https://www.ruby-forum.com/t/recommendation-for-searching-with-regards-to-timestamp-foreign-key-attributes/186466/2 "2010-04-07T15:46:36Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![ct9a](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/ad7895/32.png) [@ct9a](https://www.ruby-forum.com/u/ct9a)\
**Post date:** [April 7, 2010, 3:50pm UTC](https://www.ruby-forum.com/t/recommendation-for-searching-with-regards-to-timestamp-foreign-key-attributes/186466/3 "2010-04-07T15:50:06Z")

</div>

bravo! I like the idea, Franz! Thank you 🙂