Ah, of course, forgot the explicit :type. Good to know it's all working now :)

-- 
Pat

On 23/02/2010, at 4:01 PM, spiceee wrote:

> 
> Thanks, Pat. That and :type => :integer pulls the trick!
> 
> Cheers,
> 
> Spe.
> 
> On Feb 23, 1:53 am, Pat Allan <[email protected]> wrote:
>> Try 'has' instead of 'indexes':
>> 
>>   has "COUNT(belongings.id)", :as => :viewer_count
>> 
>> You don't need :sortable - attributes are sortable by Sphinx without needing 
>> any special settings.
>> 
>> --
>> Pat
>> 
>> On 23/02/2010, at 3:50 PM, spiceee wrote:
>> 
>> 
>> 
>> 
>> 
>>> Hey, before I crack open the TS code and start debugging, this used to
>>> work a few versions back:
>> 
>>>  define_index do
>>>    indexes name, :sortable => true
>>>    indexes created_at, :sortable => true
>>>    has belongings(:id), :as => :belongings_ids
>>>    indexes "COUNT(belongings.id)", :as => :viewer_count, :sortable =>
>>> true
>>>    set_property :delta => true
>>>  end
>> 
>>>  sphinx_scope(:by_most_views) do
>>>    {:order => "viewer_count DESC, @relevance DESC"}
>>>  end
>> 
>>>> Model.by_most_views.search("something").each {|m| puts
>>> m.belongings.size}
>>> 6
>>> 4
>>> 32
>>> 23
>>> 2097
>>> 15
>> 
>>> Does anything sound a bit off?
>> 
>>> Thanks,
>> 
>>> Spe.
>> 
>>> --
>>> 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.

Reply via email to