Hi,
I am having problem in searching the results.
If the foreign key store_id in the orders table is greater than
999, then returns the empty results. But it returns the correct result
set
when the its <=999.
How to make it working when the store_id is greater than 999?
Indexes of the order model
class Order < ActiveRecord::Base
define_index do |index|
index.includes.store_order_id
index.includes.status
index.includes.buyer_notes
index.includes.rsm
index.includes.store_id
index.includes.customer.store_customer_id
index.includes.customer(:first_name,:middle_name,:last_name).as.customer_full_name
index.includes.items(:ship_to_first_name,:ship_to_middle_name,:ship_to_last_name).as.ship_to_full_name
index.includes.items.ship_to_company
index.includes.items.ship_to_state
end
end
Search Query
orders = Order.search(:conditions => {store_order_id=>2100, :store_id
=> 1047}, :include => [:customer,:items,:batch], :per_page => 10)
--
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.
