Thanks Pat for your fast response, really appreciated Effectively the :order clause did the work.
Best. Fernando. On Wednesday, September 18, 2013 8:10:14 PM UTC+7, Pat Allan wrote: > > Hmm, that's recent enough that I doubt it's the problem. > > The ordering/group-by-ordering always gets me confused… but does the > following work more accurately: > > Tagging.search( nil, :group_by => :normalized_copy, :order => "@count > desc", :per_page => 50, :page => page ) > > I'm a little short on sleep, but I'm thinking the group-by-ordering > applies within each group, not the order of each grouped result. > > -- > Pat > > On 18/09/2013, at 11:04 PM, Fernando Petrelli wrote: > > Hi Pat, > > My sphinx version is: > > Sphinx 2.0.6-release (r3473) > > On Wednesday, September 18, 2013 7:56:06 PM UTC+7, Pat Allan wrote: >> >> Hi Fernando >> >> I appreciate all the details, though I'm not yet sure what the cause of >> the problem is. What version of Sphinx are you using? >> >> -- >> Pat >> >> On 18/09/2013, at 9:59 PM, Fernando Petrelli wrote: >> >> Hi, >> >> I'm migrating an app using TS 1.4.13 with rails 2 to a new one using TS 3 >> with rails 4. >> >> The model name is Tagging, and it has a string attribute 'normalized'. I >> want to group by this 'normalized' attribute, and sort according to the >> number of coincidences. >> >> The index is: >> >> ---------- >> define_index do >> indexes normalized, :sorted => true >> has "CRC32(normalized)", :as => :normalized_copy, :type => :integer >> end >> --------- >> >> In the old application the code for doing this was: >> >> Tagging.search( nil, :group_by => 'normalized_copy', :group_function => >> :attr, :group_clause => "@count desc", :per_page => 50, :page => page ) >> >> In the new application I'm doing this: >> >> Tagging.search( nil, :group_by => :normalized_copy, :order_group_by => >> "@count desc", :per_page => 50, :page => page ) >> >> >> A normal sql query shows that the most use tags and their respective >> counts are the following: >> ["vintage", 8351] >> ["furniture", 3882] >> ["mid century", 3691] >> ["modern", 1955] >> ["jewelry", 1746] >> >> >> The old code (TS 1.4.13 and rails 2.3.18) works great, this is what it >> returns: >> >> vintage 8351 >> furniture 3882 >> mid century 3691 >> modern 1955 >> jewelry 1746 >> >> But with the new code (TS 3.0.5 and rails 4), sort is not working. >> >> adopter 1 >> gateaux 1 >> gouter 1 >> chaine 2 >> the boss 1 >> >> This is the sphinx console log: >> >> Sphinx Query (248.8ms) SELECT *, *, @groupby, @count FROM `tagging_core` >> WHERE `sphinx_deleted` = 0 GROUP BY `normalized_copy` WITHIN GROUP ORDER BY >> @count desc LIMIT 0, 20 OPTION max_matches=250000 >> Sphinx Found 25713 results >> >> Apparently it's throwing the 'sort by @count', but it's not working, or >> maybe I'm missing something? Is this a known bug? >> >> Thank you. >> Fernando. >> >> -- >> You received this message because you are subscribed to the Google Groups >> "Thinking Sphinx" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected]. >> To post to this group, send email to [email protected]. >> Visit this group at http://groups.google.com/group/thinking-sphinx. >> For more options, visit https://groups.google.com/groups/opt_out. >> >> >> > -- > You received this message because you are subscribed to the Google Groups > "Thinking Sphinx" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected] <javascript:>. > To post to this group, send email to [email protected]<javascript:> > . > Visit this group at http://groups.google.com/group/thinking-sphinx. > For more options, visit https://groups.google.com/groups/opt_out. > > > -- You received this message because you are subscribed to the Google Groups "Thinking Sphinx" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/thinking-sphinx. For more options, visit https://groups.google.com/groups/opt_out.
