Hi Pat,
Sorry if this isn't clear - the WHERE clause *only* applies when
you're indexing... and so, because the delta index doesn't get
invoked, no SQL is involved - just Sphinx data. Which means that
your record change is tracked, but documents that change from
reviewed to non-reviewed will still appear in search results.
Thanks for the further clarification. I understand now.
So, either you can use the string/SQL snippet option in the previous
email, or you can always filter on reviewed when searching (provided
you keep that attribute):
Model.search 'foo', :with => {:reviewed => true}
Thanks also for these two ways to solve my problem. I appreciate it!
Cheers,
Andrew
----
http://airbladesoftware.com
--
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.
