where does rails get the queries for nested objects?

Question

I've got a nice 3-level nested-form using formtastic_cocoon (jquery), and now I want to be able to sort the 2nd set of items in the form.

I've got jQuery ui working no problem, so now to set and update the sort order in rails.

I started following the rails bits of railscasts sortable lists http://asciicasts.com/episodes/147-sortable-lists

The form structure is User->Tasks->Location.

In my Task Model I set index to

 def index
    @task = Task.find(params[:id],:order=>'position')
 end

def edit 
    @task = Task.find(params[:id],:order=>'position')
end

and I was expecting my console to see

... FROM 'tasks' WHERE ('users'.'id' = 12) ORDER BY ('position')

or something along those lines, but there is no order by output.

Is there somewhere else that I need to define this order?? Where does the nested_object get its relationship from? The model only?

My models are

class User < ActiveRecord::Base

     has_many :tasks
end 

class Task < ActiveRecord::Base

    belongs_to :user
end

is this really your code? def edit @task = Task.find(params[:id],:order=>'position') end — stef
– stef, Commented Feb 17, 2011 at 21:23

pedalpete · Accepted Answer · 2011-02-17 21:22:14Z

1

I changed the model to

class User < ActiveRecord::Base
     has_many :tasks, :order=>'position'
end

answered Feb 17, 2011 at 21:22

pedalpete

21.7k46 gold badges133 silver badges246 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Fernando Diaz Garrido · Accepted Answer · 2011-02-17 21:34:15Z

1

You are using the wrong model, that id is of a user, so you have to do:

User.find(params[:id]).tasks(:order => 'position ASC')

Otherwise you are just getting the task with id = 12 and not the tasks whose user_id = 12

answered Feb 17, 2011 at 21:34

Fernando Diaz Garrido

3,99521 silver badges23 bronze badges

1 Comment

pedalpete Over a year ago

changing my model to your suggestion somehow breaks the has_attached_file on the user. Not sure why.

DGM · Accepted Answer · 2011-02-17 21:36:02Z

1

From the answer that you've given, I suspect the real issue lies not in the tasks controller. The default order you gave is great, but if you had some other order or filter requirements, the tasks model won't quite do it either.

I suspect you were actually in users#edit, or possibly a _form.html.erb, where it displays the form elements for each task. There might have been a @user.tasks.each {...} or similar loop block.

For a given user then, do: @user.tasks.order(:position). Or maybe you need open tasks: @user.tasks.where(:open=>true) etc.

answered Feb 17, 2011 at 21:36

DGM

27.1k7 gold badges65 silver badges82 bronze badges

2 Comments

pedalpete Over a year ago

Are you suggesting .order(:position) in the view??

DGM Over a year ago

in the view, or you could make a scope for it.

stef · Accepted Answer · 2011-02-17 22:04:39Z

1

Your code is slightly wrong here.

To find that user's tasks you would do this in your route:

User.find(params[:id]).tasks(:order=>'position')

answered Feb 17, 2011 at 22:04

stef

14.3k2 gold badges50 silver badges70 bronze badges

Collectives™ on Stack Overflow

where does rails get the queries for nested objects?

4 Answers 4

Comments

1 Comment

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

1 Comment

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related