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