Thank you for your response and patience. I apologize for the double post
but I thought since I forgot the [Rails] tag that my post was rejected.
named_scope :not_commented_by, lambda { |user| { :include=> :comments,
:conditions => ["(submissions.id = comments.submission_id AND
comments.editor_id != ?) OR comments.id IS NULL", [user.id]] } }
I don't think this represents what you were trying to say:
select submissions.* from submissions left outer join comments on
submissions.id = submission_id AND editor_id =1 where comments.id IS NULL;
but I am not sure how to implement this statement into a find statement or
named scope. I am trying to make it so it doesn't pull comments of the page
of the current editor if that editor has commented already. So in essence
being a to do list of submissions.
I appreciate your help though I do now at least see what the issue is.
However I am still stumped on how to solve it.
I was on the right track before because I was trying to narrow doing the
submission to the comment but it never seemed to work for me. I get an error
On Sun, Nov 15, 2009 at 12:08 AM, Frederick Cheung <
frederick.che...@gmail.com> wrote:
>
>
>
> On Nov 14, 8:30 pm, upisdown <trimp...@gmail.com> wrote:
> > So I am working on this project but I am having trouble with a find
> > statement. My code is mostly working but it falls apart when more
> > entries are added.
> >
> > I am working on a submission manager. I want a table of submissions
> > for editors of a specific genre for which they haven't commented. When
> > they comment I want it removed from table so that only the submissions
> > they need to work on are showing. I tried two methods that produce the
> > same results. One I used a find statement and another I tried a named
> > scope. Right now I can filter out the submissions of the specific
> > genre and then remove ones that have been commented on but soon as a
> > second editor comments on them they show up again.
>
> See the reply I gave the first time you asked this (
>
> http://groups.google.com/group/rubyonrails-talk/browse_thread/thread/72ad9e8771d8e353#
> )
>
> Fred
> >
> > Here is my code for the named scope
> >
> > (In the submission model)
> >
> > named_scope :not_commented_by, lambda { |u| { :include
> > => :comments, :conditions => ['comments.editor_id != ? OR comments.id
> > IS NULL', u.id] } }
> >
> > (In the User Controller)
> >
> > @prose = Genre.find_by_name('Prose').submissions.not_commented_by
> > (@user)
> >
> > Here is my code for the find statement
> >
> > (In the user controller)
> >
> > @prose = Genre.find_by_name('Prose').submissions.find(:all, :include
> > => :comments, :conditions => ['comments.editor_id != ? OR comments.id
> > IS NULL', @user.id])
> >
> > Can anyone explain why this would stop working when a second comment
> > is made? Anyone have suggestions for implementing this better?
> >
> > Thank you for your time,
> > Christian
> >
>
--~--~---------~--~----~------------~-------~--~----~
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 rubyonrails-talk@googlegroups.com
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---
