query translate

Hi,
i have soem problem to translate this query :

MySQL

select oro_access_group.name from oro_access_group inner join oro_user_access_group on oro_user_access_group.group_id = oro_access_group.id where oro_user_access_group.user_id = 14

1 2 3 4

select oro_access_group.name from oro_access_group inner join oro_user_access_group on oro_user_access_group.group_id = oro_access_group.id where oro_user_access_group.user_id = 14

in a querybuilder. I dont know how to access to oro_user_access_group entity

Thanks

Topic

[Mike KudelyaParticipant]

Hi,
Can you provide source code of your querybuilder and which column do you want to access ?

[fred33Participant]

I have not yet written my querybuilder, i just want to know the group name of current user

[Mike KudelyaParticipant]

Get current user from controller

PHP

$user = $this->getUser();

1	$user = $this->getUser();

or service container

PHP

$user = $this->get('security.context')->getToken()->getUser();

1	$user = $this->get('security.context')->getToken()->getUser();

and get all user’s group objects

PHP

$groupsCollection = $user->getGroups(); foreach ($groupsCollection as $group) { $name = $group->getName(); }

1 2 3 4 5

$groupsCollection = $user->getGroups();           foreach ($groupsCollection as $group) {             $name = $group->getName();         }

[fred33Participant]

Thanks a lot

[Author]

Replies