Example for direct access of doctrine queryBuilder in TYPO3 Flow

accessDoctrineQueryBuilderExample

$q = $this->createQuery();
// hack -> we directly access the queryBuilder from the current query $q
$qb = ObjectAccess::getProperty($q, 'queryBuilder', TRUE);

$qb
    ->andWhere('e.shortName = :term')
    ->setParameter('term', $term);

if ($productType) {
    $qb
        ->leftJoin('e.type', 't')
        ->andWhere('t.value = :productType')
        ->setParameter('productType', $productType);
}

if ($hasIssue) {
    $qb
        ->join('e.issues', 'i')
        ->groupBy('e')
        ->having('COUNT(i) > 0');
}

return $q->execute();