Okay, what about the following:
ThinkingSphinx.search :conditions => {:city => '("San Jose" | "San
Francisco")'}
Note the single and double quotes.
--
Pat
On 09/06/2010, at 6:16 PM, badnaam wrote:
> 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.
>
--
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.
