"Now I just need to make sure they haven't posted a comment yet" - me
I was able to accomplish the inverse of this with: @prose = Submission.find(:all, :include => :comments, :conditions => ["comments.owner_id != ?", "@user.comments") Is there any way to have two included models and more conditionals on a single find or should I just do another find with the product of the first find like: @prose = Submission.find(:all, :include => :genre, :conditions => [" genres.name = ?", "Prose"] @proseacc = @porse.find(:all, :include => :comments, :conditions => ["comments.owner_id != ?", "@user.comments") On Mon, Nov 9, 2009 at 11:30 PM, christian <[email protected]> wrote: > This works for my purpose! > > @prose = Submission.find(:all, :include => :genre, :conditions => [" > genres.name = ?", "Prose"] > > Now I just need to make sure they haven't posted a comment yet. Thank you > guys for all your assistance! > > > On Mon, Nov 9, 2009 at 11:23 PM, christian <[email protected]> wrote: > >> Alright I hope I am posting the relevant information. >> >> Here is from my genre.rb (genre model file) >> *"class Genre < ActiveRecord::Base >> >> hobo_model # Don't put anything above this >> >> fields do >> name :string >> timestamps >> end >> >> has_many :submissions, :dependent => :destroy >> has_many :users, :dependent => :destroy"* >> >> Since I intend to sort by submissions I will post the submissions.rb next. >> >> >> *"class Submission < ActiveRecord::Base >> >> hobo_model # Don't put anything above this >> >> fields do >> title :string >> body :text >> status :string, :default => false >> timestamps >> end >> >> belongs_to :issue >> belongs_to :genre"* >> >> Then I am trying to pull these submissions with the that belong to the >> genre prose on the user page for prose editors. I have already successfully >> set it up so that prose editors see only the table I am working on so now it >> is just a matter of trying to make it so they only see relevant submissions. >> >> >> So here is my user_controller.rb >> * >> "class UsersController < ApplicationController >> >> hobo_user_controller >> >> auto_actions :all, :except => [ :new, :create ] >> >> def account >> >> @prose = Submission.find(:all, :include => :genre, :conditions => >> [ genre.name == '1' ]) >> hobo_show >> >> end"* >> >> Then this data will be displayed in account.dryml >> * >> "<if test="&logged_in? && current_user.editor? && @user.editor?"> >> >> <h3>Pending Review</h3> >> <br /> >> >> >> <table-plus with="&@prose" fields="issue, this, owner, genre, >> comments.count, judgements, created_at"> >> >> <created-at-view:><view format="%d %B %Y"/></created-at-view:> >> <controls:>Report</controls:> >> </table-plus> >> >> >> </if>*" >> >> I hope this better explains what I am trying to accomplish. I feel if I >> can pull data and run conditions from other related models against it that I >> will have a much better grasp of how to deal with data using dryml/hobo. If >> you are curious I am trying to build my friend a submission manager for a >> literary magazine and teach myself hobo in the process. >> >> Thanks again for your time and patience. >> >> >> On Mon, Nov 9, 2009 at 11:11 PM, Matt Jones <[email protected]> wrote: >> >>> >>> >>> On Nov 9, 2009, at 5:45 PM, christian wrote: >>> >>> > Genre in my case is a seperate model which both user and submissions >>> > has many and I want to sort by submissions genre. >>> > >>> > Genre has many submissions and users. Submissions belong to genre. >>> > >>> > So for this example would it be? >>> > >>> > class Submission >>> > named_scope :prose, :include => :genre, :conditions => >>> > { :submissions => >>> > { :genre => 'Prose' } } >>> > end >>> > >>> >>> That's not going to work - my examples assumed (since you were >>> referencing users.genre) that genre was a field (likely an >>> enum_string) that was defined on User. >>> >>> Can you post the relevant parts of your models, either here or in a >>> gist? >>> >>> > Thank you. I feel I already understand the process much better and I >>> > have been reading the linked tutorials which I am catching things >>> > that didn't quite make sense before. >>> >>> :) As rough as things sometimes are now, just imagine what it was like >>> back in the old 0.6 era; most of the documentation back then was "read >>> the source". Big thanks to everybody that's contributed recipes, docs, >>> or even just come on the list and said, "X doesn't make sense...". >>> >>> --Matt Jones >>> >>> >>> >>> >>> >> > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Hobo Users" 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/hobousers?hl=en -~----------~----~----~----~------~----~------~--~---
