doctrine get all reesults createQueryBuilder 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 query builder order by multiple

$qb->add('orderBy', 'first_name ASC, last_name ASC');