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]. > 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. > > -- 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.
