Unfortunately, Sphinx doesn't allow grouping by fields - which is essentially what you'd need to do, I think.
However, if you could have one/all of those fields as attributes as well, then you could group on the attributes instead - provided the values are identical. has columns_for_C, :as => :c_as_attr Model.search "whatever", :group_function => :attr, :group_by => :c_as_attr Give that a shot. Cheers -- Pat On 03/03/2009, at 8:45 PM, bikash wrote: > > Hi, > Is it possible to have unique results based on particular column/field > value? > so if A,B,C,D are the fields of a Model being indexed and say we have > following three search results > 1) a1,b1,c1,d1 > 2) a2,b2,c1,d2 > 3) a3,b3,c2,d3 > Because results 1) and 2) have same value for field C(i.e c1), so can > we filter them as being duplicate and get only one of them. > P.S. Search results are sorted based on weight > Thanks. > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
