'where not in' query with doctrine query builder

You need to use query builder expressions, and this means you need access to the query builder object. Also, the code is easier to write if you generate the subselect list ahead of time:

$qb = $em->createQueryBuilder();$nots = $qb->select('arl')          ->from('$MineMyBundle:MineAssetRequestLine', 'arl')          ->where($qb->expr()->eq('arl.asset_id',1))          ->getQuery()          ->getResult();$linked = $qb->select('rl')             ->from('MineMyBundle:MineRequestLine', 'rl')             ->where($qb->expr()->notIn('rl.request_id', $nots))             ->getQuery()             ->getResult();

It is possible to do this in one Doctrine query:

$qb  = $this->_em->createQueryBuilder();$sub = $qb;$sub = $qb->select('arl')          ->from('$MineMyBundle:MineAssetRequestLine', 'arl')          ->where($qb->expr()->eq('arl.asset_id',1));$linked = $qb->select('rl')             ->from('MineMyBundle:MineRequestLine', 'rl')             ->where($qb->expr()->notIn('rl.request_id',  $sub->getDQL()))             ->getQuery()             ->getResult();

Check the reference in this answer here