<div dir="ltr"><br><div class="gmail_extra"><br><div class="gmail_quote">On Fri, Feb 6, 2015 at 12:29 AM, Peter Rabbitson <span dir="ltr"><<a href="mailto:rabbit+dbic@rabbit.us" target="_blank">rabbit+dbic@rabbit.us</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">On 02/05/2015 09:56 PM, Seth Daniel wrote:<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<br>
...<span class=""><br>
<br>
<br>
my $rs = $s->resultset( 'A' )<br>
->search( { 'B.name' => 'some_name' },<br>
{ columns => [ 'id', { '<a href="http://A_B.B.name" target="_blank">A_B.B.name</a> => 'B.name' } ],<br>
collapse => 1,<br>
join => [ { A_B => 'B' },<br>
{ A_B => 'B' } ] } );<br>
<br>
This does return only the columns I ask for, but it also only returns<br>
the B that match the search criteria instead of all B for the selected A.<br>
</span></blockquote>
<br>
Yes - you asked for B.name to be put into <a href="http://A_B.B.name" target="_blank">A_B.B.name</a> and you also referenced it in the where condition. What you want is (likely)<br>
columns => [ 'id', { '<a href="http://A_B.B.name" target="_blank">A_B.B.name</a> => 'B_2.name' }<br>
<br>
Check the generated DBIC_TRACE=1 (and maybe in addition DBIC_TRACE_PROFILE=console) to easier wrap your head around what is going on.<br>
<br>
Cheers<br></blockquote><div><br> That was it. Thank you very much. </div></div><br></div></div>