Guyren, I erred in not thanking you for your suggestion. The custom SQL is pretty easy to do, though I need to do something similar to this across a few models and was hoping for a more AR-centric approach. Going at it from the Allocation side made it super easy.
Cheers, Chris On May 7, 4:26 pm, Guyren G Howe <[email protected]> wrote: > On May 7, 2010, at 16:02 , Chris McCann wrote: > > > This seems like a trivial problem but I'll be darned if I can get it > > to work using ActiveRecord methods. > > tl;dr :-) but I generally find when I start wondering about things like this > that some custom SQL is usually the best answer, and will usually be > considerably more efficient than doing it with Rails anyway. > > Regards, > > Guyren G Howe > Relevant Logic LLC -- SD Ruby mailing list [email protected] http://groups.google.com/group/sdruby
