Yup, using an MVA and :with_all is your best bet, I think :)
--
Pat
On 27/08/2010, at 3:28 PM, keldelice wrote:
> Should I've read the manual :-)
>
> One solution seems to be defining a multi value attribute
>
> define_index do
> indexes title, :sortable => true
>
> has location(:ancestry), :as => :loc_ids, :type => :multi
>
> end
>
> ruby-1.9.2-p0 > Organization.search_for_ids(:with_all => {:loc_ids =>
> [1,17715]}).total_entries
> => 400
>
> Great !
>
> On 26 août, 22:23, keldelice <[email protected]> wrote:
>> Reading twice what I've written to fast the search query should have
>> been
>>
>> ruby-1.9.2-p0 > Organization.search(:conditions => {:loc => "1/17715/
>> *"}, :match_mode => :phrase)
>> => []
>>
>> Which is not working
>>
>> On 26 août, 18:24, keldelice <[email protected]> wrote:
>>
>>
>>
>>> Hi,
>>
>>> Let's says that I've Organizations that belongs to a Location (always
>>> a City).
>>
>>> Location is using ancestry gem in order to create a nested set like
>>> Country > Region > County > City
>>> The nested set path is store in a column named "ancestry" (String)
>>> like "1/2/3" each / representing the parent_id
>>
>>> What I'd like to do is to find all organizations within a Region or a
>>> County
>>
>>> So in Organization model I have
>>
>>> define_index do
>>> indexes title, :sortable => true
>>> indexes location(:ancestry), :as => :loc
>>
>>> end
>>
>>> However
>>
>>> ruby-1.9.2-p0 > Location.search(:conditions => {:ancestry => "1/17715/
>>> *"}, :match_mode => :phrase)
>>> => []
>>
>>> but
>>
>>> ruby-1.9.2-p0 > Organization.where("locations.ancestry LIKE
>>> '1/17715/%'").includes(:location).count
>>> => 401
>>
>>> I've enable_star: true in sphinx.yml
>>
>>> Is there someone who has a better solution ? (Or an idea of what I've
>>> missed :)
>>
>>> Thanks
>>> Cyrille
>
> --
> 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.
