Hi all,
The setup:
I’ve got a Candidate model, and it has two associations like:
has_many :next_tasks, :class_name => ‘Task’, :foreign_key =>
‘candidate_id’, :conditions => [‘start_time > now() and not deleted =
0’], :order => ‘start_time’
has_many :previous_tasks, :class_name => ‘Task’, :foreign_key =>
‘candidate_id’, :conditions => [‘start_time < now() and not deleted =
0’], :order => ‘start_time desc’
I have a controller which is using will_paginate, which at some point is
using ActiveRecord to get a count, and it’s eager loading both of these
associations:
:include => [:status, :position, :user, { :previous_tasks => :user },
{:next_tasks => :user}, :hiring_manager]
The problem:
I’m getting an error like:
Column ‘start_time’ in on clause is ambiguous …
The two relevant areas of the clause are:
LEFT OUTER JOIN tasks ON tasks.candidate_id = candidates.id AND
start_time < now() and not deleted = 0
and
LEFT OUTER JOIN tasks next_tasks_candidates ON
next_tasks_candidates.candidate_id = candidates.id AND start_time >
now() and not deleted = 0
So, AR is smart enough to join ‘tasks’ as next_tasks_candidates, but not
to append that join name to the conditions.
This seems (notice, just seems… I don’t pretend to be a Rails expert,
demanding that this is a problem with Rails and not my code) to be a
problem with AR and doing a count on a query that is eager loading two
associations which have conditions with the same variable names in them.
Anyone have any thoughts on what I can do to fix this?
Thanks,
Luke
