symfony - Symfony2 ManyToMany inverse result -
i have 3 entities.
users
groups
user_groups
users entity contains users, groups contains groups , there manytomany relationship between these 2 entities user_groups.
in users entity can groups assigned user:
/** * @orm\manytomany(targetentity="groups", inversedby="users") * @orm\jointable(name="user_groups", * joincolumns={@orm\joincolumn(name="user_id", referencedcolumnname="id")}, * inversejoincolumns={@orm\joincolumn(name="group_id", referencedcolumnname="id")} * ) */ private $groups;
this plain , simple, how can groups not assigned user?
is there method "inverse result" of manytomany relationship?
thank you!
you can use not member of expression in querybuilder :
... ->andwhere(':user not member of g.users') ->setparameter('user', $user) ...
Comments
Post a Comment