Replying to myself again -- sad, sad, sad...
Subselects are indeed the answer -- this actually *works*!:
indexes "(SELECT string_value FROM dynamic_attribute_values WHERE
(dynamic_attribute_values.contact_id = 2032 AND
dynamic_attribute_values.dynamic_attribute_id = 16) LIMIT 1)", :as
=> :enquiry_codes
and then I can rebuild and
>> Contact.search("@enquiry_codes GCEN", :match_mode => :extended).size
=> 20
Whoop! Whoop!
Now I just need to plug it together and clean up the mess.
ThinkingSphinx totally *owns* Ferret and UltraSphinx, and with deltas
and infixes is the best search tool I've used on any platform, period.
Huge thanks for putting this out there.
-- Thomas
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
