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