php - Sort symfony users by roles -


i have user entity. implements basic user-interface.
want sort users roles , don't know how it.

(it send message admins message entity targeting user entity on manytoone relation)

$query = $this->getdoctrine()->getentitymanager()             ->createquery(                 'select u mybundle:user u u.roles :role'             )->setparameter('role', '%"role_my_admin"%');  $users = $query->getresult(); 

offload work db server. query shouldn't take long return, 100,000+ records.


Comments

Popular posts from this blog

android - Why am I getting the message 'Youractivity.java is not an activity subclass or alias' -

python - How do I create a list index that loops through integers in another list -

c# - “System.Security.Cryptography.CryptographicException: Keyset does not exist” when reading private key from remote machine -