Check if alias exists?

How I could check if the alias is already defined?

There is no method for check this.


Thats not working because I got only the ROOT alias and no join aliases.

/** @var $query \Doctrine\ORM\QueryBuilder */
$query->getRootAliases()

The parts is another invalid option for me...

$query->getDQLPart()

Returns only the parts like "select, from, etc.".

And thats the error I would "ignore".

[Semantical Error] line 0, col 254 near '_user LEFT': Error: '_user' is already defined.


**How could I check if the alias exists?**

You get this error because you're trying to join with an already defined alias.

A solution would be to check join DQL parts. In your repository method you could do something like this:


$joinDqlParts = $queryBuilder->getDQLParts()['join'];
$aliasAlreadyExists = false;

/* @var $join Query\Expr\Join */
foreach ($joinDqlParts as $joins) {
foreach ($joins as $join) {
if ($join->getAlias() === '_user') {
$aliasAlreadyExists = true;
break 2;
}
}
}

if ($aliasAlreadyExists === false) {
$queryBuilder->innerJoin('parenttable._user', '_user')

}


So you only join if you didn't joined already.

You could use PHP native `in_array` function to check if the value exists in the array or not.

in_array($alias, $qb->getAllAliases())