Select a NULL-Value

[sttn]

Hi,

when I select some entities from the Database, I will get all entities where have a null value in a column.

Example:

$collection = $this->entityManager
->getRDBRepository('TargetList')
->where([
'campaignsId' => 'NULL'
])
->find();

This does not work. What is the correct statement?

Best regards

Stefan

[yuri]

Hi Stefan,

This definitely should work:

->where(['accountId' => null])

Note that you might have the excessive "s" in "campaignsId".

[yuri]

As Campaign is related with Target List through a many-to-many relationship type, checking for null won't work. You can leftJoin 'campaigns' link with distinct applied. But I'd recommend using a sub-query in a where clause.

[sttn]

Thank you