- $qb = $this->createQueryBuilder('e')
- ->select('e')
- ->setFirstResult($firstResult)
- ->setMaxResults($maxResults)
- ->leftJoin('e.user', 'u')
- ->where('e.isArchived = true')
- ->andWhere('u.id =:userId')->setParameter('userId', $userId)
- ->orderBy('e.createdAt', 'desc')
- ->getQuery();
-
- $paginator = new Paginator($qb);
-
- return $paginator;