How can I get every user who has exactly ROLE_USER #45502

AbdelilahDerfoufi · 2022-02-21T16:38:25Z

AbdelilahDerfoufi
Feb 21, 2022

I used querybuilder method to get all the users who has ROLE_USER as a role for an admin dashboard.

Here is the method I wrote :

`{
$role = 'ROLE_USER';

    return $this->createQueryBuilder('u')
        ->where('u.roles = :role')
        ->setParameter('role', $role)
        ->getQuery()
        ->getResult();
}

`

chyshyya · 2022-02-21T17:17:44Z

chyshyya
Feb 21, 2022

We add repository method:

    public function findMembers($role)
    {
        $qb = $this->createQueryBuilder('u');

        $qb
            ->andWhere($qb->expr()->like('u.roles', ':role'))
            ->setParameter('role', '%'.$role.'%')
            ->orderBy('u.username', 'ASC');

        return $qb
            ->getQuery()
            ->getResult();
    }

9 replies

AbdelilahDerfoufi Feb 22, 2022
Author

Did you add findMembers method to UserRepository?

Yes.

AbdelilahDerfoufi Feb 22, 2022
Author

I see... ROLE_USER added by default in symfony architecture to all users you created (check method getRoles() of User entity). You can use $userRepository->findAll() to return all of users stored in database. Look to your database and chech if field roles contain ROLE_USER string at all. I think answer is no.

Ah yes, you're right

AbdelilahDerfoufi Feb 22, 2022
Author

Then I should use not like ROLE _ADMIN and without getting ROLE_SUPER_ADMIN or something qnd I should get users who have RoLe_user and [] as roles, right?

chyshyya Feb 22, 2022

I think that if you want to get users with ROLE_USER, but they must have only this role and not ROLE_CLIENT or ROLE_ADMIN or any other, then best choice to get them findMembers('[]') or to write other method that will check if roles equals '[]'

AbdelilahDerfoufi Feb 22, 2022
Author

I can add a condition if($role = '[]' || $role = 'ROLE_USER')
and we return qb, maybe this can work?

endelwar · 2025-04-17T11:06:06Z

endelwar
Apr 17, 2025

I covered this topic in a blog post a while back: https://endelwar.it/2020/08/filter-users-by-role-in-symfony-5/
The solution still works with Symfony 6.

0 replies

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

How can I get every user who has exactly ROLE_USER #45502

{{title}}

Replies: 2 comments 9 replies

{{title}}

{{title}}

{{title}}

{{title}}

{{title}}

{{title}}

{{title}}

Select a reply

How can I get every user who has exactly ROLE_USER #45502

AbdelilahDerfoufi Feb 21, 2022

Replies: 2 comments · 9 replies

chyshyya Feb 21, 2022

AbdelilahDerfoufi Feb 22, 2022 Author

AbdelilahDerfoufi Feb 22, 2022 Author

AbdelilahDerfoufi Feb 22, 2022 Author

chyshyya Feb 22, 2022

AbdelilahDerfoufi Feb 22, 2022 Author

endelwar Apr 17, 2025

AbdelilahDerfoufi
Feb 21, 2022

Replies: 2 comments 9 replies

chyshyya
Feb 21, 2022

AbdelilahDerfoufi Feb 22, 2022
Author

AbdelilahDerfoufi Feb 22, 2022
Author

AbdelilahDerfoufi Feb 22, 2022
Author

AbdelilahDerfoufi Feb 22, 2022
Author

endelwar
Apr 17, 2025