I'm trying a rather complicated sql fragment with the indexes method
of the Builder:
indexes "(SELECT GROUP_CONCAT(s.name SEPARATOR ' ')
FROM assets AS a
LEFT OUTER JOIN classifications AS cl ON (a.station_id =
cl.station_id)
LEFT OUTER JOIN categories as c on (cl.category_id = c.id)
LEFT OUTER JOIN categories as m on (c.parent_id = m.id)
LEFT OUTER JOIN categories as s on (m.parent_id = s.id)
WHERE a.id = assets.id
)", :as => 'state_classification'
The SQL produces a comma separated list of words on which the record
needs to be indexed, but searching on these words does not produce the
records.
Indexing with 'rake ts:index' works fine (no errors) and I restart
searchd to make sure.
Is this supported in thinking sphinx? The example from the
documentation 'indexes "age < 18", :as => :minor' is rather simple and
returns a boolean, so are strings not supported for indexing?
Am I missing something? Any help would be appreciated.
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
