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.
