I have the parent model of user and user has_many :events. From the user view, how can I find the most recent datetime (event.time) of event?
I'm thinking that a find_by will work, but I'm not sure on how to do that.
views:
20answers:
3
+1
A:
Something like this.
user.events.find(:first, :order => "time DESC")
You can read more here:
http://api.rubyonrails.org/classes/ActiveRecord/Base.html#M001777
Nikita Rybak
2010-08-11 02:40:35
For some reason, when find returns the results, it is in a weird format. Here's an example: `#<Event:0xb6a26708>` What's going on?
Reti
2010-08-11 03:04:34
the result returned is an Event instance. Try _result.time_
Nikita Rybak
2010-08-11 03:09:10
I'm not sure what you mean when you say `result.time`. How do I use that?
Reti
2010-08-11 03:13:35
user.events.find(:first, :order => "time DESC").time
Nikita Rybak
2010-08-11 03:13:59
Thanks, that worked perfectly. And I did have that, but I was having trouble when user didn't have any events. I added an exception and it worked. :)
Reti
2010-08-11 03:20:42
+1
A:
user.events.find(:all, :order => 'time desc', :limit => 100)
where limit is number of recent events you need or:
user.events.find(:first, :order => 'time desc')
if you need one most recent event.
SMiX
2010-08-11 02:41:38
A:
user.events.find(:first, :order => 'time desc').time
like this you can get the event time
Ramanavel
2010-08-11 05:44:04