Not sure with the grouping, but if you just need one record without any counts or such on the other rows, why not just do :limit => 1, :order_by => "..."?
On Sep 29, 7:21 am, Pete <[email protected]> wrote: > Hi, > > Does anyone have any suggestions for this? > > I am having real problems accessing one item from each column in the > database - I know it can be done using SQL, but I don't > know how to implement this into named_scope ruby syntax? > > Pete > > On Sep 28, 3:49 pm, Pete <[email protected]> wrote: > > > Hi, > > > I am currently a little confused with trying to manipulate a named > > scope that I currently have. > > I use this named scope with a table-plus, and it works very nicely, > > but I want to trim it down a little. > > > I have two associated models e.g > > > Catalogue, > > > has_many :articles > > > Article: > > > belongs_to :catalogue > > > my named scope looks like this (in Class Article) > > > :finished_articles, { :conditions => [ :finished => true ] } > > > This works fine on it's own, but I need to trim it to show only the > > most recent finished article per catalogue (based on created_at field) > > > I have tried to use two named scopes, the other looking like this: > > > :limited, { :group => "catalogue_id" } > > > which does only leave one entry per catalogue, but rather than being > > the most recent entry it is the first created. > > > I just want to be able to reverse this order, but I can't seem to > > figure out how to do this (I have a default order already set, but > > this only seems to affect the scope after it has been rendered..) Also > > setting the order does not seem to have an effect on how the instances > > are gathered from the database. -- 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.
