CODEWITHSUNDEEP
phpsymfony1doctrinesymfony-1.4doctrine-1.2
Michael Fidy
Michael Fidy

Reputation: 389

How to query NOT NULL with Doctrine?

I have table Test:

Test:
id | name 
1  | aaa
2  | 
3  | ccc
4  | aaa
5  | 
6  | ddd

I want result where name is NOT NULL:

aaa
ccc
aaa
ddd

How can i get with:

Doctrine_Core::getTable('Test')->findBy('name', NOTNULL??) <-doesnt working

and in model with:

$this->createQuery('u')
     ->where('name = ?', NOTNULL ???) <- doesnt working
     ->execute();

Upvotes: 35

Views: 85590

Answers (3)

stiweb
stiweb

Reputation: 41

Or just use Doctrine filter:

$filters[] = new Filter('name', null, 'notEqual');

Then

$list = $this->get(yourDBinstance)
        ->setDocIdentifier('TestBundle:Test')
        ->setFilters($filters)
        ->list();

Upvotes: 3

Oshan Wisumperuma
Oshan Wisumperuma

Reputation: 1948

Do it in Doctrine way, from query builder and Expr class.

 $qb = $entityManager->createQueryBuilder();
 $result = $qb->select('t')
        ->from('Test','t')
        ->where($qb->expr()->isNotNull('t.name'))
        ->groupBy('t.name')
        ->getQuery()
        ->getResult();

there are also distinct() function.

Upvotes: 21

Dziamid
Dziamid

Reputation: 11571

Try this:

$this->createQuery('u')
     ->where('name IS NOT NULL')
     ->execute();

which is standard SQL syntax. Doctrine doesn't convert Null values into proper sql.

Upvotes: 61

Related Questions