# Find :last

**URL:** <https://www.ruby-forum.com/t/find-last/104916>\
**Category:** Rails\
**Created:** [May 23, 2007, 9:10pm UTC](https://www.ruby-forum.com/t/find-last/104916 "2007-05-23T21:10:01Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![craigrails](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/c2a13f/32.png) [@craigrails](https://www.ruby-forum.com/u/craigrails)\
**Post date:** [May 23, 2007, 9:10pm UTC](https://www.ruby-forum.com/t/find-last/104916/1 "2007-05-23T21:10:01Z")

</div>

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?

–  
Craig W. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)

---

<div class="post-metadata">

**Author:** ![craigrails](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/c2a13f/32.png) [@craigrails](https://www.ruby-forum.com/u/craigrails)\
**Post date:** [May 23, 2007, 9:17pm UTC](https://www.ruby-forum.com/t/find-last/104916/2 "2007-05-23T21:17:02Z")

</div>

Like this:

Placement.find(:first, :conditions =\> [“client\_id = ? AND  
discharge\_date  
IS NULL”, self], :order =\> ‘admission\_date’).facility\_id

---

<div class="post-metadata">

**Author:** ![craigrails](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/c2a13f/32.png) [@craigrails](https://www.ruby-forum.com/u/craigrails)\
**Post date:** [May 23, 2007, 9:23pm UTC](https://www.ruby-forum.com/t/find-last/104916/3 "2007-05-23T21:23:02Z")

</div>

On Wed, 2007-05-23 at 19:15 +0000, dasil003 wrote:

> Like this:
> 
> Placement.find(:first, :conditions =\> [“client\_id = ? AND  
> discharge\_date  
> IS NULL”, self], :order =\> ‘admission\_date’).facility\_id

* * *

duh - I would have sworn that I tried that.

## Thanks - it did work

> > –  
> > Craig W. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)
> 
> >

–  
Craig W. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)