find :last

Craig_White1 · May 23, 2007, 7:09pm

I don't seem to be able to find 'last' record but only first record even though I can 'order'

Placement.find(:first, :conditions => ["client_id = ? AND discharge_date IS NULL", self], :order => 'admission_date DESC').facility_id

will still return the 'first' record without regard to the :order...how can I get the 'last' record?

Gabe_da_Silveira1 · May 23, 2007, 7:15pm

Like this:

Placement.find(:first, :conditions => ["client_id = ? AND discharge_date IS NULL", self], :order => 'admission_date').facility_id

Craig_White1 · May 23, 2007, 7:21pm

Like this:

Placement.find(:first, :conditions => ["client_id = ? AND discharge_date IS NULL", self], :order => 'admission_date').facility_id