Sorry that's my mistake the status field from other table was saving later on (thats why it was nil instead of ACTIVE) ... the solution of this problem is using delayed index.
Thanks for the reply Pat. On Oct 18, 6:56 pm, Pat Allan <[email protected]> wrote: > What does your define_index block look like? And what versions of Rails and > Thinking Sphinx are you using? > > Cheers > > -- > Pat > > On 18/10/2010, at 6:42 PM, Gull wrote: > > > Records are being getting indexed (delta) on creation. But with > > conditions clause they are not being getting appeared in result and > > with out conditions they are search able. > > > Record is in DB (records delta is true) > >>> UsedCar.last.id > > => 126015 > > > Thinking Sphinx gets the record > >>> UsedCar.search(:order=>:created_at, :sort_mode=>:desc, > >>> :match_mode=>:extended).first.id > > => 126015 > > > Thinking Sphinx did not get the record with condition clause > > ?> > > UsedCar.search(:order=>:created_at, :sort_mode=>:desc, > > :conditions=>{:status=>"ACTIVE"}, :match_mode=>:extended).first.id > > => 126014 > > > Thanks in advance. > > > -- > > 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 > > athttp://groups.google.com/group/thinking-sphinx?hl=en. > > -- 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.
