handling order with has_many through relationship

Question

I have two models: project and task (for example) with a join model: project_task enabling a has_many through relationship so that tasks may be shared across projects.

I have specified position as an attribute of the project_task model. Now I want to be able to access tasks by their position in the project_tasks table via a given project.

i.e. project.tasks (ordered by the position listed for each task in the project_tasks table).

Is this possible?

Answer 1

This is what works for me in Rails 5.x :

has_many :project_tasks
has_many :tasks, -> { order('project_tasks.position') }, through: :project_tasks

Answer 2

I think something like that can help you:

has_many :project_tasks
has_many :tasks, :through => :project_tasks, :order => 'project_tasks.position'