Hi Jochen
You need to have 'created_at' as an attribute, not a field. So add:
has created_at
And remove
indexes created_at
I would expect sphinx scopes to be evaluated when needed, not when the
model is loaded, but let me know if I'm wrong.
--
Pat
On 01/10/2009, at 12:42 AM, Jochen Kaechelin wrote:
>
>
> Am 01.10.2009 um 00:05 schrieb Pat Allan:
>
>>
>> On 01/10/2009, at 12:00 AM, Jochen Kaechelin wrote:
>>
>>>
>>> I'am not successfull in get this working:
>>>
>>> sphinx_scope(:latest_first) {
>>> { :order => 'created_at DESC' }
>>> }
>>>
>>> I always retrieve 0 hits.
>>
>> What does your define_index block look like?
>
> indexes kadisnr, :sortable => true, :unique => true, :facet =>
> true
> indexes kadis_product, :sortable => true, :unique => true
> indexes product, :sortable => true, :unique => true
> indexes order_number, :sortable => true, :unique => true, :facet
> => true
> indexes kadis_description, :sortable => true
> indexes description, :sortable => true
> indexes new_product, :sortable => true
> indexes notepads.product_id , :as => :notepads
> indexes brand, :sortable => true
> indexes boost, :sortable => true
>
> indexes created_at
>
> indexes tags.name, :as => :tags
> indexes taggings.tag_id, :as => :taggings
> has taggings(:tag_id), :as => :taggings_ids
>
> indexes active
>
> set_property :delta => true
>
>>
>>> BTW is this possible with freelancing-god-thinking-sphinx?
>>>
>>> named_scope :old_product, lambda { {:conditions => ["created_at
>>> < ?",
>>> 1.month.ago]} }
>>
>> Sphinx doesn't have the concept of greater/less-than, but you can get
>> around it with a range:
>> sphinx_scope :old_product {
>> {:with => {:created_at => (0..1.month.ago)}}
>> }
>>
>
> U missed the "(" and ")":
>
> sphinx_scope(:old_product) {
> {:with => {:created_at => (0..1.month.ago) } }
> }
>
> That works. But "0..1.month.ago" will be translated on application
> start - or?
> So it's not exactly the same as:
>
> lambda { {:conditions => ["created_at < ?",1.month.ago]} }
>
>
>> This is essentially filtering from the unix epoch (1st Jan 1970) up
>> until 1 month ago.
>>
>> Cheers
>>
>> --
>> Pat
>>
>>>
>
>
> >
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
