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.
