Thanks Pat. :sort_by works. I don't think the docs make reference to that anywhere or at least not to the :expr usage.
Also, do you know if there is a way to specify both expression and SPH_SORT_EXTENDED type sorting, like: :sort_by => "@weight+1, price ASC" And I could not get ASC or DESC to work for :expr based sort so I am guessing it always sorts DESC. Do you know if that is the case? The sphinx search docs don't seem to cover this. Thanks, Tom On Apr 3, 1:04 am, Pat Allan <[email protected]> wrote: > Sorry, that was a little terse, let me elaborate. > > :order is an ActiveRecord option - and so to make things easier, I > translate it across to :sort_by (the Sphinx equivalent), with some > smarts to ensure sorting for fields works, etc. It seems like it's not > clever enough, if it's not working in your situation. I'll look into it. > > Cheers > > -- > Pat > > On 03/04/2009, at 4:02 PM, Pat Allan wrote: > > > > > Try :sort_by instead of :order - although it would be nice if it > > worked as you stated. > > > -- > > Pat > > > On 03/04/2009, at 1:18 AM, Tom Davies wrote: > > >> I was trying to play around with expression based sorting but having > >> no luck (sphinx returns no results so I must be doing something > >> wrong). I tried something like: > > >> :sort_mode => :expr, :order => "@weight+1" > > >> just as a simple test. If anyone has a simple working example you > >> could share I would appreciate it. > > >> Thanks, > >> Tom --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
