my $details = InContact::cDBI::contact->contact_detail(recontact =
> $tm);
[download]

This doesn't work because the contact_detail method created by has_many is an instance method - if you already had an object $obj of class InContact::cDBI::contact returned by retrieve or search then you could say

my @details = $obj->contact_detail(recontact =
> $tm);
[download]

You can do something like

my @contacts = map { $_->contact_id } InContact::cDBI::contactdetail->
+search(recontact =
> $tm);
[download]

and then filter out the duplicates.

But I think you will need to use set_sql to do the kind of search you have in mind (can't give an example because I don't know what your fields are).