[Rails] Re: Filtering data using find and named scopes

you can join
you can use "detect" or "find_all" after pulling the data for first
time

these are array methods provided by ror

On Nov 15, 3:34 pm, christian <trimp...@gmail.com> wrote:
> After hours of trying this is my best guess,
>
>  @presort = Genre.find_by_name("Prose").submissions.find(:all, :include=>
> :comments, :conditions => ["comments.editor_id = ? AND submissions.id =
> comments.submission_id", @user.id])
>
> @prose = @presort | Genre.find_by_name("Prose").submissions.find(:all,
> :include=> :comments, :conditions => ["comments.editor_id != ? OR
> comments.id IS NOT NULL", @user.id])
>
> Anyone have a solution for this issue?
>
> On Sun, Nov 15, 2009 at 6:48 AM, christian <trimp...@gmail.com> wrote:
> > I think my last post may have been confusing and after re reading it I
> > would like to clarify.
>
> > So I understand I I am pulling multiple submissions for each comment since
> > I am including all comments. I need to somehow filter these comments for my
> > editor before I then remove the ones which have been commented by the
> > specific editor. I am still unclear on how to do this but I think it has to
> > do with combining two find statements.
>
> > Thanks!
>
> > On Sun, Nov 15, 2009 at 5:56 AM, christian <trimp...@gmail.com> wrote:
>
> >> 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/...
> >>> )
>
> >>> 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+unsubscribe@googlegroups.com
For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---