Hi Pat,
Its working fine but again one problem,
:conditions => {:zip => "(01234 | 56789)"} "In this i have more than 500 zip codes.If i passed whole thing in side the condition result is 0 but if i passed the less number of zip codes inside the condition it is working fine.Whether i need to mem limit in spinix.yml file .Any suggestions? Best Regards Arun Prakash C.K Keep On Sharing Your Knowledge with Others On Fri, Sep 10, 2010 at 4:45 PM, Pat Allan <[email protected]> wrote: > This is because :with_all is for filters, which only apply to attributes. > Currently you have zip as a field - which is probably the best option, as > you can't currently filter by string attributes. > > -- > Pat > > > On 10/09/2010, at 7:11 PM, Arun <[email protected]> wrote: > > Hi pat , >> Now its working fine but one doubt , can i use with_all filters >> instead of" :conditions => {:zip => "(01234 | 56789)"} " because i am >> getting the condtion like value like this >> z= [92656, 92698, 92801, 92802, 92803, 92804, 92805] >> >> @donates = Donate.search params[:search],:with_all => {:zip =>z} >> >> so result should come related to this code only but it is not working >> for me ?? >> >> Any sugesstion ? >> >> >> >> On Sep 10, 3:54 pm, Pat Allan <[email protected]> wrote: >> >>> Sphinx can only query against the information it knows about - ie: >>> what's in the index. >>> >>> So, if you want to query against zip codes, make sure you have a field >>> for that column: >>> >>> indexes zip >>> >>> Keep in mind that string attributes can't be used for filters: >>> http://freelancing-god.github.com/ts/en/common_issues.html#string_fil... >>> >>> If you want to query by multiple zip codes, then check out the sphinx >>> docs for the extended match mode syntax - you'll want to wrap all zip >>> codes together with parentheses, and separate them with OR pipes: >>> >>> Donate.search :conditions => {:zip => "(01234 | 56789)"} >>> >>> Cheers >>> >>> -- >>> Pat >>> >>> On 10/09/2010, at 6:37 PM, Arun <[email protected]> wrote: >>> >>> >>> >>> >>> >>> >>> >>> Hi Pat, >>>> >>> >>> In the donate model block is >>>> define_index do >>>> indexes title >>>> end >>>> >>> >>> On Sep 10, 3:34 pm, Pat Allan <[email protected]> wrote: >>>> >>>>> Hi Arun >>>>> >>>> >>> What does the define_index block in your Donate model look like? >>>>> >>>> >>> -- Pat >>>>> >>>> >>> On 10/09/2010, at 6:32 PM, Arun <[email protected]> wrote: >>>>> >>>> >>> thanks i have installed 2.0.0.rc2 and in the filters i am using the >>>>>> array only. >>>>>> >>>>> >>> Even though i perforemd search like this >>>>>> donate = Donate.search "Stringer", :conditions => {:zip =>91795} >>>>>> Stringer word is matched with zipcode but result is not retrieving >>>>>> and >>>>>> also i regenerated the index and i restarted the servers also >>>>>> what to >>>>>> do ? >>>>>> >>>>> >>> On Sep 10, 3:16 pm, Pat Allan <[email protected]> wrote: >>>>>> >>>>>>> Hi Arun >>>>>>> >>>>>> >>> What does your define_block look like?Because you can't use string >>>>>>> attributes for filters. >>>>>>> >>>>>> >>> Also, probably best using 2.0.0.rc2 - though that shouldn't change >>>>>>> anything in this situation. >>>>>>> >>>>>> >>> Cheers >>>>>>> >>>>>> >>> -- >>>>>>> Pat >>>>>>> >>>>>> >>> On 10/09/2010, at 6:12 PM, Arun <[email protected]> wrote: >>>>>>> >>>>>> >>> Hi friend, >>>>>>>> I have installed the "gem 'thinking-sphinx', '2.0.0.rc1', :require >>>>>>>> => >>>>>>>> 'thinking_sphinx'" in the rails 3 application >>>>>>>> >>>>>>> >>> Search function is working but Attribute Filters,field condtions >>>>>>>> is >>>>>>>> not working >>>>>>>> >>>>>>> >>> I need to search donation name with matched zipcodes only ,so i >>>>>>>> used >>>>>>>> like this >>>>>>>> @donates = Donate.search params[:search],:with_all => {:zip => >>>>>>>> zipcodes.collect(&:zipcode)} >>>>>>>> >>>>>>> >>> But it is retrieving the result even it not matching also and i >>>>>>>> tried >>>>>>>> like this in console to check sphinx >>>>>>>> >>>>>>> >>> Donate.search "Stringer", :conditions => {:zip => '91795'} >>>>>>>> zip code belongs to "stringer" but it is also not retrieving >>>>>>>> >>>>>>> >>> where i am doing wrong?? >>>>>>>> >>>>>>> >>> -- >>>>>>>> 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]<thinking-sphinx%[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]<thinking-sphinx%[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]<thinking-sphinx%[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]<thinking-sphinx%[email protected]> >> . >> For more options, visit this group at >> http://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]<thinking-sphinx%[email protected]> > . > For more options, visit this group at > http://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.
