Order by size desc


#1

ok so i am trying to order the results by the total size in a desc
order, here is what i have so far and its not working

def show
@reports = Report.find(:all, :group => ‘user_id’, :order =>
‘user_id.size desc’ )
end

anybody know how to go about doing this


#2

On Wed, Jan 21, 2009 at 11:54 AM, Dan P. removed_email_address@domain.invalid wrote:

ok so i am trying to order the results by the total size in a desc
order, here is what i have so far and its not working

def show
@reports = Report.find(:all, :group => ‘user_id’, :order =>
‘user_id.size desc’ )
end

anybody know how to go about doing this

Hi, it seems that you’re trying to access an attribute of a User table
called size and
this isn’t possible with the above. Thus, you’ll need to do something
like
the following:

Report.all( :joins => :user, :group => “user_id”, :order => “size desc”
)

The key thing here is to use :joins to access the users table within the

query. This allows one to access the fields in the query without
displaying

the data of that attribute.

Good luck,

-Conrad


#3

Awesome, thanks for the reply i shall give it a try