Hi, I've got posts with a bunch of tags joined against them, only certain tag types should be used for the attribute. The whole dataset gets grouped by the Post's id.
I'm defining a custom attribute for my Sphinx index using something like the following has "GROUP_CONCAT(CASE tag.tag_type WHEN 'Normal' THEN tag.tag ELSE NULL END)', :type => :string, :as => :normal_tag but this is triggering an active record NoMethodError: . It is trying to find a method on the model matching that piece of SQL? This is only causing a problem during search, index seems to be happy with it, and I've looked at the generated SQL and that appears to be fine? Is custom SQL supported for the attributes? Thanks jebw -- 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.
