I need sphinx to sort the results by the sum of an attribute. I need to:
- Group the results by their IDs (done)
- Sort the results by the SUM of one attribute
I can't find a way to sum this attribute. How could I do this?
(Im using sphinx PHP API)
I need sphinx to sort the results by the sum of an attribute. I need to:
I can't find a way to sum this attribute. How could I do this?
(Im using sphinx PHP API)
Sphinx supports aggregate functions (sum, avg, min, max) since 0.9.9-rc2 version. Check the documentation from www.sphinxsearch.com/docs/current.html