i want to list every libraries, but only show the your books with more than 100 pages.
On 31 jul, 18:15, Colin Law <[email protected]> wrote: > 2009/7/31 Italo Matos <[email protected]>: > > > > > but, if me put the conditions in find method, > > it will filter much libraries ( if libraries has more one book with > > more than 100 pages ). > > I don't understand. Your original query would give you everything, the > modified one will only give you Libraries and books with greater than > 100 pages which is what I thought you asked for. To quote 'i would > like to create a xml with all Libraries, but books with pages more > than 100'. Perhaps I do not understand exactly what you mean, could > you give a more detailed example of what you want? > > Colin > > > > > On 31 jul, 17:10, Colin Law <[email protected]> wrote: > >> 2009/7/31 Italo Matos <[email protected]>: > > >> > I can`t put the conditionbs in the Library.find, because this > >> > relashionship is uses in other part of code. > >> > How to call named scope in this case? > > >> I meant use render :xml=> Library.find(:all, :include => :books, > >> :conditions => ['books.pages >= ?', 100]).to_xml(:include=>books) > > >> Or define a named_scope books_with_more_than_100_pages, though I > >> suspect you would actually parameterise this, then > >> render :xml=> > >> Library.books_with_more_than_100_pages.to_xml(:include=>books) > > >> The above not tested so probably full of typos. > > >> By the way it is generally frowned upon to top post in this list. > > >> Colin > > >> > On 31 jul, 16:44, Colin Law <[email protected]> wrote: > >> >> 2009/7/31 Italo Matos <[email protected]>: > > >> >> > i have: > > >> >> > class Library << ActiveRecord::Base > >> >> > has_many :books > >> >> > end > > >> >> > class Book << ActiveRecord::Base > >> >> > belongs_to :library > >> >> > end > > >> >> > in my controller i have: > > >> >> > render :xml=> Library.find(:all).to_xml(:include=>books) > >> >> > but, i would like put a condition in the books ( e.: pages >= 100 ) > > >> >> > i would like to create a xml with all Libraries, but books with pages > >> >> > more > >> >> > than 100) > > >> >> Just put the conditions in the Library.find call, ie ["books.pages >= > >> >> ?", 100] or similar. Or better still provide a named scope in Library > >> >> to do this. > > >> >> Colin --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
