Error while filtering

[fsteinbauer]

Type error: Argument 1 passed to Knp\Component\Pager\Event\Subscriber\Filtration\Doctrine\ORM\Query\WhereWalker::expressionContainsFilter() must be an instance of Doctrine\ORM\Query\AST\ConditionalExpression, instance of Doctrine\ORM\Query\AST\ConditionalTerm given, called in /vendor/knplabs/knp-components/src/Knp/Component/Pager/Event/Subscriber/Filtration/Doctrine/ORM/Query/WhereWalker.php on line 192

This error occurs, when the query is built with the query builder. If no filter is specified it works like a charm.

An example of the filter params:
?filterField=e.name&filterValue=example

Querybuilder

(It works when the between is commented out. After I comment this line in, the error above occurs. The Between statement is not the problem, it also occurs with a simple eq)

$qb = $this->createQueryBuilder('e');
$qb->orderBy('e.adressZip', 'ASC');
$qb->leftJoin('e.vertreter', 'u')
                ->leftJoin('u.vertretungen', 'v')
                ->andWhere($qb->expr()->orX(
                    $qb->expr()->eq('e.vertreter', ':userid'),
                    $qb->expr()->isNull('e.vertreter'),
                    $qb->expr()->andX(
                        $qb->expr()->eq('v.proxy', ':userid')
           //                    ,    $qb->expr()->between(':currentDate', 'v.start', 'v.end')
                    )
                ))
                ->setParameter('currentDate', new \DateTime(), \Doctrine\DBAL\Types\Type::DATETIME)
                ->setParameter('userid', $user->getId());

return $qb->getQuery();

[nicolasmure]

Hello,

If you do not plan to have multiple expressions in your andX function (as the above example where the second expression is commented), I think you should replace the andX by its first expression directly :

->andWhere($qb->expr()->orX(
    $qb->expr()->eq('e.vertreter', ':userid'),
    $qb->expr()->isNull('e.vertreter'),
    $qb->expr()->eq('v.proxy', ':userid')
))

[fsteinbauer]

Hey @nicolasmure !

This is not the issue, both issues in the andX are needed. Just if the second one is uncommented, symfony crashes with the above stated exception.

[fsteinbauer]

push

[nicolasmure]

Hello,

Do you mind to make a repository having this bug so we can investigate on this ?

Thank you ;)

[garak]

Please follow related issue in knp-components