How did you do it with integers? Thanks.
On Wednesday, January 30, 2013 11:06:15 PM UTC+1, Matt Bilbow wrote: > > nevermind I was being a dumbass, thanks Pat > > On Thursday, 10 June 2010 13:50:16 UTC+1, Pat Allan wrote: >> >> 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 unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/thinking-sphinx?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
