Rails List wrote:
> Joao Silva wrote:
>> Here are my scopes:
>>
>> default_scope :order => 'posted_on DESC', :conditions => { :status =>
>> 'visible' }
>> named_scope :positive, :conditions => { :rating => 'positive', :status
>> => 'visible' }
>> named_scope :neutral, :conditions => { :rating => 'neutral', :status
>> => 'visible' }
>> named_scope :negative, :conditions => { :rating => 'negative', :status
>> => 'visible' }
>> named_scope :ignored, :conditions => { :status => 'ignored' }
>>
>> Why i'm getting ALL records when i run these scopes? Whatever scope i
>> run i'm getting all records, whatever i set 'visible' or 'ignored' state
>> :-(.
>
> How do you run them?. You should be as clear as possible to get
> appropriate answers.
Migration:
create_table "messages", :force => true do |t|
t.string "rating", :default => "neutral"
t.boolean "ignored", :default => false
t.datetime "created_at"
t.datetime "updated_at"
end
Class:
class Message < ActiveRecord::Base
default_scope :order => 'posted_on DESC', :conditions => { :ignored =>
false }
named_scope :positive, :conditions => { :rating => 'positive' }
named_scope :neutral, :conditions => { :rating => 'neutral' }
named_scope :negative, :conditions => { :rating => 'negative' }
named_scope :ignored, :conditions => { :ignored => true }
named_scope :commented, lambda {
message_ids = Comment.connection.select_values("SELECT message_id
FROM comments")
{:conditions => {:id => message_ids}}
}
named_scope :today, :conditions => ['created_at BETWEEN ? AND ?',
Time.now.beginning_of_day, Time.now.end_of_day]
end
Message.ignored -> returns all records :-(
--
Posted via http://www.ruby-forum.com/.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Ruby
on Rails: Talk" 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/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---
