php - Symfony left join query -


i've got following query running correctly:

$q = $this->createquery('e')      ->where('e.persons_iduser =?', $request)      ->leftjoin('e.jobtitles jt')      ->leftjoin('e.employmentlevels el'); 

but when i'm iterate through result , try access fields left join:

 foreach ($work $w){    echo $w->employername;    echo $w->jobtitle; // left join    echo $w->employmentlevel; // left join  } 

i got following error message: unknown record property / related component "jobtitle" on "experiences"

anyone got clue? how echo field left join?

<?php     foreach ($work $w){         echo $w->employername;         foreach($w->jobtitles $job){             echo $job->jobtitle; // left join         }         foreach($w->employmentlevels $employ){             echo $employ->employmentlevel; // left join         }     }  ?> 

this work symfony returns array of objects , elements join table come under child array


Comments

Popular posts from this blog

android - Spacing between the stars of a rating bar? -

html - Instapaper-like algorithm -

c# - How to execute a particular part of code asynchronously in a class -