Symfony2 Doctrine Expr 'IS NOT NULL'

doctrine-orm, symfony

Solution

You can use `isNotNull`:

'query_builder' => function ($er){
    $qb = $er->createQueryBuilder('p');
    $qb
        ->where($qb->expr()->andx(
            $qb->expr()->in('p', '?1'),
            $qb->expr()->isNotNull('p.location')
        ))
        ->setParameter(1, $this->totalScope);

    return $qb;
},

Problem

I'm using the FormType for an Entity of mine, and setting up an entity field. I need two `Where` clauses in an `And`, and from what I've read on the Query Builder page, this is at least how I should go about it: ``` 'query_builder' => function ($er){ $qb = $er->createQueryBuilder('p'); $qb ->where($qb->expr()->andx( $qb->expr()->in('p', '?1'), $qb->expr()->not( $qb->expr()->eq('p.location', 'NULL') ) )) ->setParameter(1, $this->totalScope) ; return $qb; }, ``` However, the `not(eq('col', 'NULL'))` doesn't achieve the desired result, and in fact, errors with: Error: Expected Literal, got 'NULL'

Original source