i. The $queryIdentifier was set wrong in the Toolbox Bundle (assets.id instead of id). Therefore the resulting query contained assets.assets.id which is a non-existing field.
ii. $query->where() and $query->groupBy() overrides the conditions/groups which are being applied by Pimcore in the Listing which leads to a parameter mismatch. Using andWhere() and addGroupBy() fixes that.
Join Behaviour
Using $query->join() performs an inner join which means that only assets, etc. with some restrictions defined appear in the result set. All without any definitions will be cut off.
Using $query->leftJoin() keeps also results without restriction-definitions.
Description
There are basically two things to fix:
Query
i. The
$queryIdentifierwas set wrong in the Toolbox Bundle (assets.idinstead ofid). Therefore the resulting query containedassets.assets.idwhich is a non-existing field. ii.$query->where()and$query->groupBy()overrides the conditions/groups which are being applied by Pimcore in the Listing which leads to a parameter mismatch. UsingandWhere()andaddGroupBy()fixes that.Join Behaviour
Using
$query->join()performs an inner join which means that only assets, etc. with some restrictions defined appear in the result set. All without any definitions will be cut off. Using$query->leftJoin()keeps also results without restriction-definitions.