# Order\_by From another Model Field

**URL:** <https://www.ruby-forum.com/t/order-by-from-another-model-field/186985>\
**Category:** Rails\
**Created:** [April 15, 2010, 9:21am UTC](https://www.ruby-forum.com/t/order-by-from-another-model-field/186985 "2010-04-15T09:21:44Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![ashu](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/a/4bbf92/32.png) [@ashu](https://www.ruby-forum.com/u/ashu)\
**Post date:** [April 15, 2010, 9:21am UTC](https://www.ruby-forum.com/t/order-by-from-another-model-field/186985/1 "2010-04-15T09:21:44Z")

</div>

trying to order\_by From another Model Field  
if params[:order\_by] == ‘name’  
@object = Object.paginate(:all, :page =\>  
self.page\_number, :per\_page =\> 50, :order =\> “#{params[:order\_by]}”)  
elsif params[:order\_by] == ‘last\_updated\_another\_model\_object’  
@object  
= ???  
end  
Thanks in Advance.

---

<div class="post-metadata">

**Author:** ![ashu](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/a/4bbf92/32.png) [@ashu](https://www.ruby-forum.com/u/ashu)\
**Post date:** [April 15, 2010, 9:32am UTC](https://www.ruby-forum.com/t/order-by-from-another-model-field/186985/2 "2010-04-15T09:32:17Z")

</div>

Field name last\_update  
Model name any\_one

On Thu, Apr 15, 2010 at 12:58 PM, Colin L. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)  
wrote:

> What do want to order by in this case?  
> For more options, visit this group at  
> [http://groups.google.com/group/rubyonrails-talk?hl=en](http://groups.google.com/group/rubyonrails-talk?hl=en).

–  
Thanks:  
Rajeev sharma

---

<div class="post-metadata">

**Author:** ![ashu](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/a/4bbf92/32.png) [@ashu](https://www.ruby-forum.com/u/ashu)\
**Post date:** [April 15, 2010, 9:30am UTC](https://www.ruby-forum.com/t/order-by-from-another-model-field/186985/3 "2010-04-15T09:30:31Z")

</div>

On 15 April 2010 08:20, ashu [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote:

> trying to order\_by From another Model Field  
> if params[:order\_by] == ‘name’  
> @object = Object.paginate(:all, :page =\>  
> self.page\_number, :per\_page =\> 50, :order =\> “#{params[:order\_by]}”)  
> elsif params[:order\_by] == ‘last\_updated\_another\_model\_object’  
> @object  
> = ???

What do want to order by in this case?

Colin

---

<div class="post-metadata">

**Author:** ![ashu](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/a/4bbf92/32.png) [@ashu](https://www.ruby-forum.com/u/ashu)\
**Post date:** [April 15, 2010, 9:58am UTC](https://www.ruby-forum.com/t/order-by-from-another-model-field/186985/4 "2010-04-15T09:58:03Z")

</div>

On 15 April 2010 08:30, kannav rajeev [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote:

> Field name last\_update  
> Model name any\_one

It is better to post your reply in the appropriate place in the  
previous email, it makes it easier to follow the thread. I understand  
when you say you want to order by the field last\_update, ( :order =\>  
:last\_update ) but what do you mean by sorting on a model named  
any\_one?

Colin

---

<div class="post-metadata">

**Author:** ![ashu](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/a/4bbf92/32.png) [@ashu](https://www.ruby-forum.com/u/ashu)\
**Post date:** [April 15, 2010, 10:37am UTC](https://www.ruby-forum.com/t/order-by-from-another-model-field/186985/5 "2010-04-15T10:37:16Z")

</div>

> **[Ruby on Rails Order By Using Associated Model](http://thedevelopercorner.blogspot.com/2009/03/ruby-on-rails-order-by-using-associated.html)**
>
> It is very easy to use an 'order by' clause in a model in Ruby on Rails. Supposing you have a Category model it's as simple as doing this: @...

I Got It Thanks For Replying all.

On 4/15/10, Colin L. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote:

> Colin
> 
> > > > self.page\_number, :per\_page =\> 50, :order =\> “#{params[:order\_by]}”)  
> > > > You received this message because you are subscribed to the Google G.  
> > > > –  
> > > > [http://groups.google.com/group/rubyonrails-talk?hl=en](http://groups.google.com/group/rubyonrails-talk?hl=en).

–  
Thanks:  
Rajeev sharma