I managed to get this working, after following a few breadcrumbs. Thanks for the kick in the right direction. The solution I came upon was to provide :type => :multi to the attribute definition, like so:
has connection_ids, :type => :multi I don't remember seeing this documented anywhere. I found it by tracing through the source for the #has method, which eventually led me to Attribute#to_sphinx_clause, which gave me the answer. I've tried this in various ways, for kicks, and it seems to work with custom SQL expressions, etc. My hand-crafted config file would've been identical to what TS is now producing -- a config that selects my connection_ids column in the `sql_query` and an extra `sql_attr_multi` definition for the same column. christian. On Sun, Mar 8, 2009 at 3:42 PM, Harold A. Giménez Ch. < [email protected]> wrote: > What does the hand-crafted config for this look like? You could probably > create a SQL function that would provide what you need, and pass it over to > the TS indexes method. > > > On Sun, Mar 8, 2009 at 4:20 PM, Christian Niles <[email protected] > > wrote: > >> >> Hi All, >> >> I've got a column on my users table containing a set of cached IDs >> that I'd like Sphinx to index as an MVA. The IDs in this column take a >> long time to calculate (they come from an external web service), and >> are serialized as a comma-separated list of integers -- perfect for >> Sphinx. >> >> I know how I could get Sphinx itself to index these columns with a >> hand-crafted config file, but is there a way to achive this through >> Thinking Sphinx? If not, can I use Thinking Sphinx well with a custom >> Sphinx setup? >> >> thanks! >> christian. >> >> >> > > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
