[Dbix-class] Thoughts about "complex" searches.

[David Kamholz]

You should be able to do:

my $rs = Track->search({ 'artist.birth' => { '<', $date } }, { join  
=> 'artist' });

Where 'artist' is the name of the relationship in the Track class.

Regards, Dave (ningu)

On Dec 6, 2005, at 9:58 AM, Jesper Krogh wrote:
>
> Artists: (aid, name,birth, etc, etc)
> Tracks: (tid,aid,name,recorded, etc. etc.)
>
> I'd like to search for the "joined set". Give me the tracks that
> has been recorded by artists born before a given date.