FOS bundle – How to select users with a specific role?

by

Just add this in your UserRepository or replace $this->_entityName by YourUserBundle:User:

/**
 * @param string $role
 *
 * @return array
 */
public function findByRole($role)
{
    $qb = $this->_em->createQueryBuilder();
    $qb->select('u')
        ->from($this->_entityName, 'u')
        ->where('u.roles LIKE :roles')
        ->setParameter('roles', '%"'.$role.'"%');

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

If you are using FOSUser Groups you should use:

/**
 * @param string $role
 *
 * @return array
 */
public function findByRole($role)
{
    $qb = $this->_em->createQueryBuilder();
    $qb->select('u')
        ->from($this->_entityName, 'u')
        ->leftJoin('u.groups', 'g')
        ->where($qb->expr()->orX(
            $qb->expr()->like('u.roles', ':roles'),
            $qb->expr()->like('g.roles', ':roles')
        ))
        ->setParameter('roles', '%"'.$role.'"%');

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

More Related Contents:

  1. Should everything really be a bundle in Symfony 2.x?
  2. Symfony2 : How to get form validation errors after binding the request to the form
  3. How to update a single library with Composer?
  4. How to check if an user is logged in Symfony2 inside a controller?
  5. Using Relationships with Multiple Entity Managers
  6. How can I run symfony 2 run command from controller
  7. Symfony2: how to log user out manually in controller?
  8. passing data from controller to Type symfony2
  9. How to specify the scope of Google API to get the birthday
  10. Symfony 2 : multiple and dynamic database connection
  11. In Symfony2, why is it a bad idea to inject the service container, rather than individual services?
  12. How to inject the @request into a service?
  13. There is no extension able to load the configuration for “facebookbundle” symfony2
  14. How can I deploy Symfony in a subdirectory?
  15. How does the login check_path route work without default controller/action?
  16. Symfony 2: Creating a service from a Repository
  17. How to get config parameters in Symfony2 Twig Templates
  18. How to check if a user is logged in Symfony2 inside a controller?
  19. The method name must start with either findBy or findOneBy. Undefined method Symfony?
  20. Symfony2 and Doctrine – Error: Invalid PathExpression. Must be a StateFieldPathExpression
  21. Doctrine – A new entity was found through the relationship
  22. Build a form having a checkbox for each entity in a doctrine collection
  23. Twig: render vs include
  24. How do I get the user IP address in Symfony2 controller?
  25. How to get list of all routes of a controller in Symfony2?
  26. Symfony2 error 500 instead of 404 at production
  27. How to add custom link or button to SonataAdminBundle Dashboard in Symfony2
  28. Adding Captcha to Symfony2 Login Page
  29. Symfony2 default locale in routing
  30. symfony2 chained selectors

Leave a Comment