Get role from team_user table

[mfonsatti]

Hi ,
how can i get "role" from the table "team_user" having the user_id and team_id ? is there a way to do that without direct SQL ?

[tanya]

Hi,
you can see this data with ORM

https://forum.espocrm.com/forum/developer-help/38933-i-m-not-access-the-team_user-table

[mfonsatti]

here my approach ...

/** @var Team $team */
$team = $this->getEntityManager()->getEntity('Team','revisors');


$entityCollection1 = $this->getEntityManager()
    ->getRepository('Team')
    ->findRelated(
        $team,
        'users',
        [
            'additionalColumnsConditions' =>
                [
                    'role' => 'financial',
                    'userId' => $data->userId,
                ]
        ]
    );

$entityCollection2 = $this->getEntityManager()
    ->getRepository('Team')
    ->findRelated(
        $team,
        'users',
        [
            'additionalColumnsConditions' =>
                [
                    'role' => 'operation',
                    'userId' => $data->userId,
                ]
        ]
    );

if($entityCollection1->count() > 0) { ... }

if($entityCollection2->count() > 0) { ... }

what i need to do is to check if the user related to a team with id "revisors" got the role "operation" or "financial" in the table team_user
is there a way to load the role attribute to make a switch case on role attribute ?