Limiting a search to records from last_request_at...
Posted
by bgadoci
on Stack Overflow
See other posts from Stack Overflow
or by bgadoci
Published on 2010-05-26T19:30:11Z
Indexed on
2010/05/26
19:31 UTC
Read the original article
Hit count: 180
I am trying to figure out how to display a count for records that have been created in a table since the last_request_at of a user.
In my view I am counting the notes
of a question
with the following code:
<% unless @questions.empty? %>
<% @questions.each do |question| %>
<%= h(question.notes.count) %>
end
end
This is happening in the /views/users/show.html.erb
file. Instead of counting all the notes
for the question, I would only like to count the notes that have been created since the users last_request_at
datetime. I don't neccessarily want to scope notes to display this 'new notes' count application wide, just simply in this one instance.
To accomplish I am assuming I need to create a variable in the User#show action and call it in the view but not really sure how to do that.
Other information you may need:
class Note < ActiveRecord::Base
belongs_to :user
belongs_to :question
end
class Question < ActiveRecord::Base
has_many :notes, :dependent => :destroy
belongs_to :user
end
© Stack Overflow or respective owner