Displaying 1 result from an estimated 1 matches for "monthly_income".
2010 Dec 02
0
Thinking Sphinx sorting problem
...no records returned. I have checked and
double checked and the query that 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 prett...