Find last record updated

Abel · October 3, 2008, 7:13pm

I always get confused when I have to make a search with Active Record a little beyond the most ordinaire. How do I find the record that was updated the last? It has to be something like

Ad.find :conditions => updated_at = :last

I just don't know how to code it.

Bart_Zonneveld · October 3, 2008, 7:16pm

Ad.find :first, :order => "updated_at DESC", :limit => 1

cheers, bartz

Pardee_Roy · October 3, 2008, 7:20pm

Does this work?

Ad.find(:first, :order => "updated_at DESC")

Abel · October 3, 2008, 9:08pm

Thanks Roy and Bart. Both sentences work and return the same record.

11175 · October 5, 2008, 8:24am

Abel wrote:

I always get confused when I have to make a search with Active Record a little beyond the most ordinaire. How do I find the record that was updated the last? It has to be something like

Ad.find :conditions => updated_at = :last

How about Ad.find :first, :order => 'updated_at DESC'