I am trying to define a scope whose condition is on an associated
model. In plain English I want to list all users in my site that are
active instructors. I will also want a scope for inactive instructors.
Can someone please help me with the syntax of the scope condition?
define_index do
indexes :username, :sortable => true
indexes :first_name, :sortable => true
indexes :last_name, :sortable => true
indexes instructor_profile.bio #referreing to the association will
force a JOIN in the sql so that the table name can be used as a
condition in the :where
where "instructor_profiles.instructor_id IS NOT NULL"
has :created_at
end
sphinx_scope(:active_instructors) do
{:conditions => {'instructor_profile.status' => 1}}
end
I've also tried this, which also hasn't worked:
{:conditions => {'instructor_profiles.status' => 1}}
--
You received this message because you are subscribed to the Google Groups
"Thinking Sphinx" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/thinking-sphinx?hl=en.
