Thinking Sphinx

Search criteria
1.Searching with the combination of the “AND” and “OR” conditions for
four to five fields of the table.
-Added the indexes for the search fields.
Ex1. Order.search(:conditions=>[“store_id=16 and
(store_order_id=‘23432’ or store_customer_id=‘23432’)” ])
-This query is returning the empty result set.

Ex2.
Order.search(:conditions=>{:store_id=>16,:store_order_id=>“23432”,:store_customer_id=>“23432”})
-This query works perfectly,but this is a combination of the “AND”
condition.

Trying to find a solution to search on the multiple fields combined with
“AND” and “OR” conditions.

Regards,
Raghu

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs