Hi,
I have the following code that is close to working the way I want it to: Dispatch.find(:all, :group => :order_id, :conditions => ["ex_factory_date < ?", (Date.today + 1.month)], :order => :ex_factory_date)
So let me quickly explain what is going on. I have orders that have many dispatches. I am trying to make a report so that I find the earliest dispatch of an order and then not to show any more dispatches for that order. So my data is basically like this: Order 1 has 3 Dispatches with the following ex_factory_dates: Dispatch 1 = 12/10/2010 Dispatch 2 = 13/10/2010 Dispatch 3 = 20/10/2010
Order 2 has 2 Dispatches with the following ex_factory_dates: Dispatch 1 = 15/10/2010 Dispatch 2 = 11/10/2010
So in my code I am using :group to ensure the order_id is unique which it does. The only problem is that it seems to only select the last dispatch and I can not think of a way to make it select the dispatch with the earliest ex_factory_date. Hope that makes sense and any help much appreciated. I may be going about this the wrong way not sure. Thanks.
