Hi guys,

I have the following index definition:

  define_index do
    indexes first_name
    indexes last_name
    has role_id
    where "state = 1 AND role_id = 6"
  end

When I run rake thinking_sphinx:rebuild (or reindex), I get this
output:

indexing index 'user_core'...
collected 418 docs, 0.0 MB
collected 134 attr values
sorted 0.0 Mvalues, 100.0% done
sorted 0.0 Mhits, 100.0% done
total 418 docs, 987 bytes
total 4.749 sec, 207 bytes/sec, 88.00 docs/sec

>From what I get here, there should be 418 users indexed. But when I
run a search count, I get this:

ruby-1.8.7-p334 :035 > User.search_count
 => 67

I tried to figure out why I don't get the right number of users,
which, if I do an SQL select using the condition "state = 1 AND
role_id = 6" is 418 users; what am I missing here. Pat, any ideas? :))

Thank you!

-- 
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.

Reply via email to