Displaying 1 result from an estimated 1 matches for "household_memb".
2010 Dec 02
0
Thinking Sphinx sorting problem
...t TS is indexing is working out, but the
problem is with the controller.
Here is what I''m indexing:
----------------------------------------------------------
indexes "((#{AppSystem::Income::BASE} - applications.monthly_income *
12)) +
SUM(#{AppSystem::Income::ADDITIONAL} -
(COALESCE(household_members.monthly_income, 0) * 12))",
:sortable => true, :as => :applicant_need, :joins =>
:household_members,
:type => :float
----------------------------------------------------------
It''s a pretty complex index, but again it is working. It creates an
index of a float...