Re: Searches via might-have

[prev] [thread] [next] [Date index for 2004/06/15]

On Tue, Jun 15, 2004 at 11:24:43AM +0100, Simon Cozens wrote:
> What I'd now like to do is call something on MyApp::Food (preferably) to
> search for best before dates between X and Y. Is this possible, or do
> I have to do the search on MyApp::Date and map them back to ->food?

To do that generically would probably involve writing some pretty hairy SQL, 
so I think your best bet is to add a search_by_date or somesuch on
MyApp::Food that runs the search on MyApp::Date and maps the results back.

Tony