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