ROLES in QueryBuilder Symfony 4
toihidpublic 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'); }