Great :) -- Pat
On 10/06/2010, at 7:06 PM, badnaam wrote: > That did it!! > > Thanks. > > On Jun 9, 4:36 am, Pat Allan <[email protected]> wrote: >> Okay, what about the following: >> >> ThinkingSphinx.search :conditions => {:city => '("San Jose" | "San >> Francisco")'} >> >> Note the single and double quotes. >> >> -- >> Pat >> >> On 09/06/2010, at 6:16 PM, badnaam wrote: >> >>> xxx - San Francisco >>> yyy - San Jose >> >>> Both ThinkingSphinx.search :conditions => {:city => "(xxx | yyy)"} and >>> ThinkingSphinx.search :conditions => {:city => "(yyy | xxxx)"} >> >>> return a single record corresponding to "yyyy". There should be two >>> record returned one each. >> >>> Thanks >> >>> On Jun 8, 12:32 am, Pat Allan <[email protected]> wrote: >>>> That's pretty much the answer I was looking for... two questions: >> >>>> - What are xxx and yyy? >>>> - What happens if you just do the following search: >> >>>> ThinkingSphinx.search :conditions => {:city => "(xxx | yyy)"} >> >>>> -- >>>> Pat >> >>>> On 08/06/2010, at 4:08 AM, badnaam wrote: >> >>>>> I am trying to allows the user to filter through the searches i.e. A >>>>> typical use case would be. >> >>>>> 1 - User searches for "abc" near zip code 10000 within 10 miles >>>>> 2 - I present the initial search results and all the facets returned >>>>> as check boxes i.e. categories, articles categories and city these >>>>> records are associated with >>>>> 3 - User might select one or more of these facets for further >>>>> filtering. If it's a class facets I construct the "classes" array if >>>>> it's a combination of other facets (i.e. user select two cities xxx >>>>> and yyy) I construct a condition hash and I expect results that >>>>> contain xxx OR yyy cities. >> >>>>> Here is the actual query my application issues.. >> >>>>> ThinkingSphinx.facets "", :with=>{"@geodist"=>0.0..16093.44, >>>>> "class_crc"=>3448190970}, :conditions=>{"city"=>"(xxx | >>>>> yyy)"}, :geo=>[0.658336879619334, >>>>> -2.13225004421321], :class_facet=>true, :latitude_attr=>:lat, >>>>> :classes=>nil, :page=>1, :per_page=>nil, :longitude_attr=>:lng, >>>>> :all_facets=>true >> >>>>> Does this answer your question? >> >>>>> On Jun 7, 2:43 am, Pat Allan <[email protected]> wrote: >>>>>> I'm really not sure why this isn't working... but let's start with real >>>>>> data - what's the actual query you're searching for? >> >>>>>> And, what are you trying to get from the query? Not the specific >>>>>> objects, but the reason for making this search request. >> >>>>>> -- >>>>>> Pat >> >>>>>> On 07/06/2010, at 12:16 PM, badnaam wrote: >> >>>>>>> Here is the irb output, it seems it doesny even query my merchant >>>>>>> model, just queries the article model. >> >>>>>>> here is the define index for them >> >>>>>>> http://pastie.org/994460 >> >>>>>>>>> ThinkingSphinx.facets :all_facets => true, :conditions => {:city => >>>>>>>>> "(xxxx | yyyy)"} >>>>>>> Sphinx Querying: '@city (xxxx | yyyy)' >>>>>>> Sphinx (0.005233s) Found 1 results >>>>>>> Article Load (0.2ms) SELECT * FROM `articles` WHERE >>>>>>> (`articles`.`id` IN (1)) >>>>>>> Sphinx Querying: '@city (xxxx | yyyy)' >>>>>>> Sphinx (0.005373s) Found 1 results >>>>>>> Article Load (0.2ms) SELECT * FROM `articles` WHERE >>>>>>> (`articles`.`id` IN (1)) >>>>>>> ArticleTag Load (1.3ms) SELECT * FROM `article_tags` WHERE >>>>>>> (`article_tags`.`id` = 4) >>>>>>> Sphinx Querying: '@city (xxxx | yyyy)' >>>>>>> Sphinx (0.004669s) Found 1 results >>>>>>> Article Load (0.1ms) SELECT * FROM `articles` WHERE >>>>>>> (`articles`.`id` IN (1)) >>>>>>> Sphinx Querying: '@city (xxxx | yyyy)' >>>>>>> Sphinx (0.004139s) Found 0 results >> >>>>>>> On Jun 6, 7:11 pm, badnaam <[email protected]> wrote: >>>>>>>> Pat - that doesnt work. >> >>>>>>>> On Jun 5, 7:44 pm, Pat Allan <[email protected]> wrote: >> >>>>>>>>> Try that last one (with the parentheses inside the string), without >>>>>>>>> an explicit match mode: >> >>>>>>>>> ThinkingSphinx.facets( >>>>>>>>> :all_facets => true, >>>>>>>>> :conditions => {:city => "(xxx | yyy)"} >>>>>>>>> ) >> >>>>>>>>> -- >>>>>>>>> Pat >> >>>>>>>>> On 06/06/2010, at 5:40 AM, badnaam wrote: >> >>>>>>>>>> result1 = ThinkingSphinx.facets :all_facets => true, :conditions => >>>>>>>>>> {:city => "(xxx | yyy)"}, :match_mode => :boolean #> no luck either >> >>>>>>>>>> On Jun 5, 12:34 pm, badnaam <[email protected]> wrote: >>>>>>>>>>>> result1 = ThinkingSphinx.facets :all_facets => true, :conditions >>>>>>>>>>>> => >>>>>>>>>>>> {:city => ("xxx: | "yyy")} #=> throws error NoMethodError: >>>>>>>>>>>> undefined method `|' for "yyy":String >> >>>>>>>>>>> On Jun 5, 12:33 pm, badnaam <[email protected]> wrote: >> >>>>>>>>>>>> Thanks Pat. That does not work though.. >> >>>>>>>>>>>> result1 = ThinkingSphinx.facets :all_facets => true, :conditions >>>>>>>>>>>> => >>>>>>>>>>>> {:city => ("xxx | yyy")} #=> doesn't work >>>>>>>>>>>> result1 = ThinkingSphinx.facets :all_facets => true, :conditions >>>>>>>>>>>> => >>>>>>>>>>>> {:city => ("xxx")} #=> 1 result--correct >>>>>>>>>>>> result1 = ThinkingSphinx.facets :all_facets => true, :conditions >>>>>>>>>>>> => >>>>>>>>>>>> {:city => ("yyy")} #=> 1 result correct >> >>>>>>>>>>>> this is on irb console. >> >>>>>>>>>>>> What am I doing wrong? >> >>>>>>>>>>>> On Jun 4, 10:27 pm, Pat Allan <[email protected]> wrote: >> >>>>>>>>>>>>> You'll need to join the values together yourself: >> >>>>>>>>>>>>> :city => "(#{a} | #{b})" >> >>>>>>>>>>>>> -- >>>>>>>>>>>>> Pat >> >>>>>>>>>>>>> On 05/06/2010, at 9:13 AM, badnaam wrote: >> >>>>>>>>>>>>>> Is it possible to do a condition like >> >>>>>>>>>>>>>> :conditon => {:city => [a, b]} ? >> >>>>>>>>>>>>>> city is a field not an index. if this wont work (it doesnt >>>>>>>>>>>>>> actually), >>>>>>>>>>>>>> what other option do I have? >> >>>>>>>>>>>>>> Thanks >> >>>>>>>>>>>>>> -- >>>>>>>>>>>>>> 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 >>>>>>>>>> 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 >>>>>>> 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 >>>>> 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 >>> 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. > -- 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.
