Hi Pat, Would you mind showing me how I can do this with integers?
Thanks, Matt 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] <javascript:>. > >>>>>>>>>>>>>> To unsubscribe from this group, send email to > [email protected] <javascript:>. > >>>>>>>>>>>>>> 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] <javascript:>. > >>>>>>>>>> To unsubscribe from this group, send email to > [email protected] <javascript:>. > >>>>>>>>>> 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]<javascript:> > . > >>>>>>> To unsubscribe from this group, send email to > [email protected] <javascript:>. > >>>>>>> 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]<javascript:> > . > >>>>> To unsubscribe from this group, send email to > [email protected] <javascript:>. > >>>>> 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]<javascript:> > . > >>> To unsubscribe from this group, send email to > [email protected] <javascript:>. > >>> 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]<javascript:> > . > > To unsubscribe from this group, send email to > [email protected] <javascript:>. > > 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.
