# Order a Find Based on Attribute of Related Table

**URL:** <https://www.ruby-forum.com/t/order-a-find-based-on-attribute-of-related-table/114710>\
**Category:** Rails\
**Created:** [September 17, 2007, 1:24pm UTC](https://www.ruby-forum.com/t/order-a-find-based-on-attribute-of-related-table/114710 "2007-09-17T13:24:39Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![ebrad](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/e/13edae/32.png) [@ebrad](https://www.ruby-forum.com/u/ebrad)\
**Post date:** [September 17, 2007, 1:24pm UTC](https://www.ruby-forum.com/t/order-a-find-based-on-attribute-of-related-table/114710/1 "2007-09-17T13:24:39Z")

</div>

I have two tables in a one-to-one relationship. Let’s call them  
orders and invoices. In the “list” page for “invoices”, how do I setup  
my find so I can display them in order of “created\_at” dates of the  
“orders” table, instead of “created\_at” of the “invoices” table?

I thought I could do something like this, but it returns “no method  
error”.

@invoices = Invoice.find(:all).order.find(:all, :order =\> ‘created\_at  
DESC’)

or

@invoices = Invoice.find(:all, :order =\> “#{Invoice.order.created\_at}  
DESC”)

---

<div class="post-metadata">

**Author:** ![ebrad](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/e/13edae/32.png) [@ebrad](https://www.ruby-forum.com/u/ebrad)\
**Post date:** [September 25, 2007, 11:02pm UTC](https://www.ruby-forum.com/t/order-a-find-based-on-attribute-of-related-table/114710/2 "2007-09-25T23:02:35Z")

</div>

You Rock!!

---

<div class="post-metadata">

**Author:** ![ebrad](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/e/13edae/32.png) [@ebrad](https://www.ruby-forum.com/u/ebrad)\
**Post date:** [September 25, 2007, 11:05pm UTC](https://www.ruby-forum.com/t/order-a-find-based-on-attribute-of-related-table/114710/3 "2007-09-25T23:05:37Z")

</div>

> or
> 
> @invoices = Invoice.find(:all, :order =\> “#{Invoice.order.created\_at}  
> DESC”)

Invoice.find(:all, :include =\> [:orders], :order =\> ‘orders.created\_at  
DESC’)