ROLES in QueryBuilder Symfony 4

Posted by
    public function userSelectBox(UserRepository $u): QueryBuilder
    {
    	$role = 'ROLE_SCHOOL';
          return $u->createQueryBuilder('u')
		        ->where('u.roles LIKE :roles')
		        ->setParameter('roles', '%"'.$role.'"%')
	            ->andWhere('u.active = :active')
	            ->setParameter('active', 1)		        
             	->orderBy('u.id', 'DESC');
     }

Leave a Reply