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 at
http://groups.google.com/group/thinking-sphinx?hl=en.
