createquerybuilder doctrine from any entity code example
Example 1: doctrine order by
<?php
// $qb instanceof QueryBuilder
$qb->select('u')
->from('User', 'u')
->where('u.id = ?1')
->orderBy('u.name', 'ASC');
Example 2: doctrine where
// $qb instanceof QueryBuilder
$qb->select('u')
->from('User', 'u')
->where('u.id = :id')
->setParameter('id', 1);