Hi there, I've looked through the archives and have tried several of
their work arounds but am not able to resolve my own issue with
indexing a sql fragment.
basically, i have something called an asset with an expire_at datetime
attribute. I want to index unexpired assets as follows:
indexes "expire_at is null or expire_at < NOW()", :as
=> :active_asset, :type => boolean
it looks like it indexes correctly, but the search result
ThinkingSphinx::Search.search('some term', :conditions =>
{:active_asset => true}) always return an empty set. the same thing
happens when i set :active_asset => false so something is wrong here.
Anyone have any ideas on my syntax or how I could examine the index to
see what the indexer is actually doing in terms of indexing that sql
fragment?
Thanks in advance for any help
s.park
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---