Hi Pat! Integer Attributes.
I have many industries and would like to do something like Agriculture (db id = 1) or Metalurgy (db id = 2). On Monday, May 27, 2013 12:48:24 PM UTC+2, Pat Allan wrote: > > Are we talking about fields containing numbers, or integer attributes? > > -- > Pat > > On 27/05/2013, at 8:13 PM, Treeninja wrote: > > > 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] <javascript:>. > > To post to this group, send email to > > [email protected]<javascript:> > . > > Visit this group at http://groups.google.com/group/thinking-sphinx?hl=en > . > > For more options, visit https://groups.google.com/groups/opt_out. > > > > > > > > -- 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.
