];
//Set the request
- $req = 'SELECT l.id, l.title, l.short
+ $req = 'SELECT l.id, l.title
FROM RapsysAirBundle:UserLocation AS ul
JOIN RapsysAirBundle:Location AS l ON (l.id = ul.location_id)
WHERE ul.user_id = :uid';
$rsm->addEntityResult('RapsysAirBundle:Location', 'l');
$rsm->addFieldResult('l', 'id', 'id');
$rsm->addFieldResult('l', 'title', 'title');
- $rsm->addFieldResult('l', 'short', 'short');
//Send result
return $em