Displaying 1 result from an estimated 1 matches for "applicant_need".
2010 Dec 02
0
Thinking Sphinx sorting problem
...''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 that is a Max income to qualify (MIQ) minus Total
Household Income (THI) MIQ - THI and...