Order List Objects from ManyToOneRelation

[genfish]

Hi, is it possible or what is the best practice to sort a list by a field of another class that is bound with ManyToOneRelation?

Like this example (not works):

Article has a field "user" ManyToOneRelation to User class.
User has a field "username".

$ArticleList = new Article\Listing();
$ArticleList->setOrderKey("user.username");
$ArticleList->setOrder("DESC");

Thanks!!!

[genfish]

Would this be a correct solution?

$ArticleList->onCreateQueryBuilder(function (\Doctrine\DBAL\Query\QueryBuilder $queryBuilder) use ($ArticleList) {
	$table = $ArticleList->getDao()->getTableName();
	$queryBuilder->leftJoin($table, 'object_query_$idUserTable', 'user', "user.oo_id = $table.user__id")->orderBy('user.username', 'DESC');
});

[markus-moser]

Yes something like this (via onCreateQueryBuilder) is the best possible solution to do this directly with an object list.

[genfish]

But when using onCreateQueryBuilder, it stops ->setCondition from taking effect, doesn't it? Should it be added in or after?

[markus-moser]

No, setCondition() should still work. It should not make really a difference if you define the condition in onCreateQueryBuilder or with setCondition as the conditions are added anyways to the query builder in this method:

pimcore/lib/Model/Listing/Dao/QueryBuilderHelperTrait.php

Line 36 in 130fd27

$this->applyConditionsToQueryBuilder($queryBuilder);