http://qs321.pair.com?node_id=1207079


in reply to Trouble with Join/Prefetch in DBIx::Class

duff++

To expand upon his answer, you need a one-to-one relationship or at least search conditions that result in only one TblRequest per TblPerson if you want it work the way you have it written. You could also loop through each of the tbl_requests to get the status.

  • Comment on Re: Trouble with Join/Prefetch in DBIx::Class